Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a Date filter on my entire app (applicable on all the sheets) which gets auto selected on app opening by selecting a max of all the dates in a "ValuationDate" column.
On sheet 2 of my app, I have a table with 3 columns. Column 1 is just labels.
Code for the 2nd column is as below:
Only(pick(match(ValueList('Discount','Commitment','Price'),
'Discount', 'Commitment', 'Price'),
Num([Discount],'##0.00%'),Num([Original Commitment],'#,##0'),Num([MktPrice],'##0.00%')))
In my third column I want to show the exact same items in the second column but with "ValuationDate" being the 2nd maximum (instead of the max in the table).
How do I go about amending my expression so that the default valuation date filter is negated and instead the 2nd max valuation date is applied only to this particular 3rd column only?
Max({<ValuationDate=>} ValuationDate, 2)
-Rob
Thanks Rob for your response.
Where in my existing expression should I apply your solution? Apologies, I am a complete beginner to Qlik.
I tried to modify Num([Discount],'##0.00%')
to
Num({Max({<ValuationDate=>} ValuationDate, 2)} [Discount],'##0.00%')
but it does not work.