Discussion Board for collaboration related to QlikView App Development.
I have a date field starting from 26-Nov-2009 . . . . etc.
I have a list box with field called "Week" but it shows actual week number from 48 49 50. . . etc
I want it as 1 2 3 .
How would I achieve this. ? Thanks in Advance
Go to Solution.
Sure. If the week numbers are based on a field or variable called baseDate:
=Week - week(baseDate) + If(Week >= week(baseDate), 1, 52)
(refactored slightly to reduce the calculations, but mathematically the same).
Assuming your start date is fixed, how about
=If(Week >=48, Week - 47, Week + 4)
hey dienst thanks for the solution.
your coding works perfectly, but is there any solution, if my date is not fixed.
yes, when i used a variable it worked.
Thanks a lot.