topic Re: Fixing a date variable in QlikView

Fixing a date variable

Wed, 06 Aug 2014 12:08:04 GMT

Hi I wanted to fix a variable based on the date so if the user selects different dates in other fields it doesn't change.

So wanted something like - vCurrentWave = Max(Date of event) the only trouble is I tried this and it keeps changing when users select fields

Any help really appreciated

tresB — Wed, 06 Aug 2014 12:10:21 GMT

Use set analysis like:

vCurrentWave = Max({1} [Date of event])

Wed, 06 Aug 2014 12:49:51 GMT

Thanks for your help I tried it in a text box and it didn't work do I need to set up a set analysis. I must be doing something wrong