Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You are missing total,try like =max(total DT_LCL)
You mean in a list box? You can try expression, like: =Max(Total DateField)
did you tried
=max(DATE_FIELD)
please give us more Information or share a sample qvw.
Regards
tim
i have tried it says invalid dimension
Have you tried with your field name in place of 'DateField' ?
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
in Dimension you have to use
=aggr(max(DATE_FIELD), DATE_FIELD)
yes
max(DT_LCL)
not working still
You are missing total,try like =max(total DT_LCL)