topic Re: Variable Definition in QlikView

Variable Definition

grgabj — Tue, 06 Sep 2022 06:44:22 GMT

I have a calendar which when i choose a riskcarrier it gives me the max date, this is the function:

=date(max([LASTREFRESH_DATE]))

but when i select a specific date in the calendar the variable definition gives me numbers : 44628

why?

i want to be able to select a specific date , but when i re select a specific filter i want it to give me my variable ( max date ) , it just goes away and it gives nothing , it gives the selected date in the calendar that i chose. Please help

Re: Variable Definition

Or — Tue, 06 Sep 2022 08:05:31 GMT

Max(Field) will give the max value of the field for the current selections. If you'd like the overall max value ignoring selections, use Max({1} Field) or Max(ALL Field)

Re: Variable Definition

grgabj — Tue, 06 Sep 2022 10:42:01 GMT

That's not it , I need to be able to get the max bi filter , but once i select a date from the calendar , the date is saved as the calendar date and the variable is gone , so once i repick a filter , the date doesnt give the max anymore !

Re: Variable Definition

SchalkF — Tue, 06 Sep 2022 13:02:11 GMT

Hello,

Try this:

=date(max([LASTREFRESH_DATE]), 'dd/mm/yyyy')