Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

How to display max of value into Text Box...

Hi All,

I have One filed, For Ex,  filed Name Called ID ,

ID

---

1

2

3

4

5

6

7

8

9

10

....

here i want display max(id) and min(id) into different two text box(or table box) same time and suppose when i am select any ID(1 or 2) it won't be change that text box value(For Ex ,Max ID is 10, Min ID is 1) it's static and display text color value maximum value is GREEN and minimum value is RED.In that text value directly pass the two input box.how to do it?  i try to write using set analysis($) function but its failed. please help me this.

Regards,

Raja.

Tags (1)
10 Replies
Not applicable

Re: How to display max of value into Text Box...

Hello Raja,

You can do this to get the max and min of ID,

=Max({<ID>}ID) for max

=Min({<ID>}ID) for Min

Hope this helps.

Thanks & Regards,

Venkat T

Not applicable

Re: How to display max of value into Text Box...

=max({<ID= >}ID)

=min({<ID= >}ID)

Hope this helps.

regards,

MT

nizamsha
Valued Contributor

Re: How to display max of value into Text Box...

PFA

Not applicable

Re: Re: How to display max of value into Text Box...

You forgot the equal (=) sign.

regards,

MT

Not applicable

Re: How to display max of value into Text Box...

Thanks to all...

Not applicable

Re: How to display max of value into Text Box...

Hi All,

i want to display max of fifth ID into text box , i try to write below syntax but it's failed.Rank function not list out our text box.Please help me how to display top values into text box.

=Aggr(if(rank(ID)>=5,ID),ID)

=if(rank(ID)>=5,ID)

Regards,

Raja.

Not applicable

Re: How to display max of value into Text Box...

I dont really understand your problem could you give an example please.

regards,

MT

Not applicable

Re: How to display max of value into Text Box...

Hi,

Add 2 text fields, open the propertiy window of text max and in thext type it as =MIN(fieldname)

Not applicable

Re: How to display max of value into Text Box...

Hi KBS_Tamm,

Thanks for your quick response,

I  have One filed, For Ex,  filed Name Called ID ,

ID

---

1

2

3

4

5

6

7

8

9

10

i want display top five values(For Ex : 6,7,8,9,10 using rank function ) into one text box.

Regards,

Raja.

Community Browser