Filters in the expressions

[saurabh_Qlik1]

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? 

[rwunderlich]

Max({<ValuationDate=>} ValuationDate, 2)

-Rob

[saurabh_Qlik1]

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.