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

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

Mon, 07 Apr 2014 10:42:22 GMT

Hi All,

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

---

....

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.

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

Mon, 07 Apr 2014 11:12:03 GMT

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

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

Mon, 07 Apr 2014 11:15:10 GMT

=max({<ID= >}ID)

=min({<ID= >}ID)

Hope this helps.

regards,

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

nizamsha — Mon, 07 Apr 2014 11:28:27 GMT

PFA

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

Mon, 07 Apr 2014 11:39:40 GMT

You forgot the equal (=) sign.

regards,

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

Wed, 09 Apr 2014 04:54:46 GMT

Thanks to all...

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

Wed, 09 Apr 2014 05:35:07 GMT

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.

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

Wed, 09 Apr 2014 05:44:45 GMT

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

regards,

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

Wed, 09 Apr 2014 05:50:54 GMT

Hi,

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

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

Wed, 09 Apr 2014 06:37:38 GMT

Hi KBS_Tamm,

Thanks for your quick response,

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

---

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

Regards,

Raja.

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

Wed, 09 Apr 2014 11:01:56 GMT

hi could you please post a sample file so i can try something out. I need to see how your data looks and with rank to show the top 5 your on a wrong train ;-).

regards,