Discussion board where members can get started with QlikView.
How can I right a variable in the script that count the number of Months Year to date
Let say we are in Jan it should be 1 if we are in February it is 2
let vVariable= num(month(today()));
with this, on every reload, the output of your variable will be the month number of day of the reload..
in Jan it will be 1, in May it will 5 etc
May be this?
maybe something like:
let vVariable= num(month(<Date>)) - num(month(today()));
The above is for example if perhaps your financial year starts in any other month than Jan
Did you got the answer, if yes post the resolution which might help others else post some sample data here so that community can help you