topic Re: FirstSortedValue is not returning single value in set analysis. in QlikView

FirstSortedValue is not returning single value in set analysis.

Fri, 30 May 2014 19:32:20 GMT

Hi,

The FIrstSortedvalue is not working in this expression....If used alone it returns single date but it seems it is return NULL in set analysis..

Sum(Aggr(If(MonthName(Min({1}TxnDate)) = 'May 2013'), Sum({<TxnDate={$(=Date(FirstSortedValue((TxnDate), Aggr(Min({<TxnType={'Invoice'}>}TxnDate),CustomerListID, TxnDate))),'MM/DD/YYYY')}>}Amount), 0), CustomerListID))

Any idea?

Saurabh

Re: FirstSortedValue is not returning single value in set analysis.

Fri, 30 May 2014 20:17:17 GMT

What about this expression in textbox?

$(=Date(FirstSortedValue((TxnDate), Aggr(Min({<TxnType={'Invoice'}>}TxnDate),CustomerListID, TxnDate))),'MM/DD/YYYY')

regards

Darek

Re: FirstSortedValue is not returning single value in set analysis.

Fri, 30 May 2014 21:36:23 GMT

Hi Darek,

BOth expressions work in textbox but they do not work when i used them in expression....

BTW..is it possible to use the value of textbox in a expression.?

Re: FirstSortedValue is not returning single value in set analysis.

Anonymous — Fri, 30 May 2014 22:00:48 GMT

Hi, Ramya.

Try encircling the $() in single quotes:

Sum(Aggr(If(MonthName(Min({1}TxnDate)) = 'May 2013'), Sum({<TxnDate={'$(=Date(FirstSortedValue((TxnDate), Aggr(Min({<TxnType={'Invoice'}>}TxnDate),CustomerListID, TxnDate))),'MM/DD/YYYY')'}>}Amount), 0), CustomerListID))

Hope it helps.

Re: FirstSortedValue is not returning single value in set analysis.

Fri, 30 May 2014 22:13:26 GMT

Nope!
It did not work..