topic Re: Output of the expression in QlikView

Output of the expression

shivani_singhal — Mon, 24 Apr 2017 07:21:51 GMT

What is the exact meaning of this expression and what will be the output?

=FirstSortedValue({<Paid_Date = {"<=$(=Date(Upto,'D/M/YYYY')) "}>} Outstanding,-Paid_Date)

Re: Output of the expression

Anonymous — Mon, 24 Apr 2017 07:31:40 GMT

It gives the 1st value of the Outstanding with the max Paid_Date which is less that the selected Upto Date.

Re: Output of the expression

shivani_singhal — Mon, 24 Apr 2017 09:23:25 GMT

Could you please explain how its giving me the maximum paid date.

Also.. what does (-Paid_Date) indicate?

Re: Output of the expression

Anonymous — Mon, 24 Apr 2017 11:13:46 GMT

Imagine you have the following table:

FieldA, FieldB

A, 3

B, 4

C, 1

D, 2

If you run a FirstSortedValue(FieldA, FieldB) you'll get the first sorted value from FieldA based on the sorting of FieldB. Value 1 is the first value for FieldB so the function will in this example return C. (FirstSortedValue())

So if we keep "-" before the field B, it will be sorted in reverse order, returning B which is value for Max value in FieldB.

Same is the case with PaidDate(field B) and outstanding(Field A).

And again set analysis is applied to filter the values based on FieldB.

Re: Output of the expression

shivani_singhal — Mon, 24 Apr 2017 12:39:58 GMT

So..it will fetch the latest Paid_Date and will give the outstanding on the basis of this latest Paid_Date...Am I right Shiva?

Re: Output of the expression

Anonymous — Mon, 24 Apr 2017 12:53:12 GMT

... as long as there's exactly one distinct value matching...

Re: Output of the expression

shivani_singhal — Mon, 24 Apr 2017 12:57:40 GMT

Thanks Robin. I got my answer.

Re: Output of the expression

Anonymous — Mon, 24 Apr 2017 12:58:01 GMT

Latest paid Date which is less than selected "Upto" value

Re: Output of the expression

shivani_singhal — Mon, 24 Apr 2017 13:14:32 GMT

Thank you so much Shiva for solving this query.