topic Firstsorted value set analysis exclusion of Year selection in QlikView

Firstsorted value set analysis exclusion of Year selection

vishsaggi — Mon, 07 Nov 2016 16:07:39 GMT

Hello All,

Seems like tricky, but trying to figure out how to exclude current selections in a table with Firstsortedvalue expressions.

PFA the sample and inside a text box that explains the problem.

Please let me know if i have not made it clear.

Appreciate your time.

Many thanks,
V.

Re: Firstsorted value set analysis exclusion of Year selection

Nicole-Smith — Mon, 07 Nov 2016 16:48:40 GMT

Change expression for Admit Date to:

FirstSortedValue({<Year=>}Admit_Date, Aggr(only({<Year=>}Date(Charge_Date, 'MM/DD/YYYY ')),Patient_Name, Encounter, Charge_Date))

The "{<Year=>}" tells the expression to ignore any selections in the Year field. You can add other fields (like month) if you wanted to treat them the same way, i.e. {<Year=, Month=>}

Re: Firstsorted value set analysis exclusion of Year selection

vishsaggi — Tue, 08 Nov 2016 13:28:11 GMT

Superb,. Thanks very much Nicole for the expression, it worked. Ha i completely forgot about this Only() and trying to complicate the expression. Appreciate your time.