Max Date on Filter Pane

[poojashribanger]

Hi

I have a requirement wherein i have a date field containing all the dates from 2016 till present .

I need to show only Max Date IN Filter pane.

Please help

[tresesco]

You mean in a list box? You can try expression, like: =Max(Total DateField)

[zhadrakas]

did you tried

=max(DATE_FIELD)

please give us more Information or share a sample qvw.

Regards

tim

[poojashribanger]

i have tried it says invalid dimension

[tresesco]

Have you tried with your field name in place of 'DateField' ?

[poojashribanger]

i have date field containing all the dates from 2016 till present.

From this field in filter pane I just have to show  one single date i.e max(date)  In qlik sense

[zhadrakas]

in Dimension you have to use

=aggr(max(DATE_FIELD), DATE_FIELD)

[poojashribanger]

yes

max(DT_LCL)

[poojashribanger]

not working still

[tresesco · Accepted solution]

You are missing total,try like =max(total DT_LCL)