topic Re: Max Date in QlikView

Max Date

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have SalesDate column derived as dual( 'Month End ' &Date(Monthend(Date),'DD-MMM-YYYY'),Date).

I want to show always only one selected SaleDate value. When I open the application it should show max(SalesDate).

How to achieve this?

I am using below.Not working.

Anonymous — Tue, 25 Oct 2016 04:15:56 GMT

Hi Jack,

can you explain your problem in detail. Sorry here I am getting it .

Thanks,

tresB — Tue, 25 Oct 2016 04:33:09 GMT

Try search string like:

= 'Month End ' &Date(Monthend(Max({1}Date)),'DD-MMM-YYYY')

nagarjuna_kotha — Tue, 25 Oct 2016 04:47:06 GMT

hi,

Try this Below Exoresion :

On Open >> Se;ction Field |>> Search Field:

= 'Month End ' &Date(Monthend(Max(Date)),'DD-MMM-YYYY')

I hope this helps.

-Nagarjun