topic max in QlikView

max

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

HI all ,

I want to set a trigget upon active sheet ...

But this is not working

I want to sleect the max date ..

How do we do this ?

and also i have a table ...in which i have sorted like below ...

this will not list properly if i clear the selections

Match(Cutomers,'17.7','17.8','17.8','17.9','17.10','17.11','17.12')

this order shoul remain constant even if clear everything

please do suggest

Thanks in advace

kusumanchir — Tue, 22 Aug 2017 05:04:38 GMT

Hi John,

The search string should be prefixed with '=' because '=Max(LDate)' is an expression.

Regards,

Rasly.K

tresB — Tue, 22 Aug 2017 05:06:02 GMT

Try a formatting your max date. Try like: =Date(Max(LDate), 'ldateformathere') // '=' sign is needed in search string

For other query, try exp:

=Only({1}Match(Cutomers,'17.7','17.8','17.8','17.9','17.10','17.11','17.12'))

and/or

uncheck 'State' from Sort By in Sort tab.