Discussion Board for collaboration related to Creating Analytics for QlikView.
hi currently i have an date field which stretches my weeks association above current week,
i.e this week is week 33, my field week has assocations to week 54.
what i am looking to do is create a set analysis statement using the current week.
i have tried the following without success;
in normal case of course you can use max(Week) however in my case not.
any help is greatly appreciated.
How about this:
or, if you can pre-calculate the current week as a variable in the load script, you could use the variable: