topic Re: displaying maximum value and date in text box in QlikView

displaying maximum value and date in text box

Fri, 20 Jun 2014 04:19:37 GMT

Hi community,

I had a case where i need to display date and maximun of count of some value for that date in a text box like as below

date - value.

I acheived this through script

But my problem here is the value should change according to selection monthly or weekly which is not happening. How can i do this using expressions directly?

Re: displaying maximum value and date in text box

PrashantSangle — Fri, 20 Jun 2014 04:24:32 GMT

Hi,

Just Nullify the other field which affect your max data.

Use this in set analysis.

Regards,

Re: displaying maximum value and date in text box

tresB — Fri, 20 Jun 2014 04:25:15 GMT

Max(Date) - for max date

FirstSortedValue( field, - Date) - value of a field against max date

Re: displaying maximum value and date in text box

Fri, 20 Jun 2014 05:44:46 GMT

Sorry, but i didn't get you. can you please explain me in detail. If possible with some example

Re: displaying maximum value and date in text box

Fri, 20 Jun 2014 05:52:49 GMT

But i need to do some grouping right, wrt date so that i can ge the max(value)

Re: displaying maximum value and date in text box

tresB — Fri, 20 Jun 2014 06:05:29 GMT

Share your sample data/qvw and state expected output.

Re: displaying maximum value and date in text box

Fri, 20 Jun 2014 09:13:02 GMT

jus assume a case where i had date and viewers for that partcular date like below

date viewers

21 150

14 100

06 200

21 250

14 250

06 325

Now i want to get the (sum(viewers)) grouped by date

date sumof viewers

21 400

14 350

06 525.

Then from the above i need to display ina text box, maximum viewers and its corresponding date, minimum values and its corresponding date in a text box like below

max date 06-525

mindate -14-350

Re: Re: displaying maximum value and date in text box

Fri, 20 Jun 2014 10:24:09 GMT

Find the PFA,may you get the idea to solve your requirement..

Re: Re: displaying maximum value and date in text box

tresB — Fri, 20 Jun 2014 10:45:53 GMT

='Maximum Viewers:' &MAx(Aggr(Sum(Viewers), Date))

='Maximum Viewers - Date:' &FirstSortedValue(Aggr(Date,Date),-Aggr(Sum(Viewers), Date))