Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Contributor II

Number of Months

Dear ALL,

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

Please help

thank you

4 Replies
Highlighted
Esteemed Contributor

Re: Number of Months

Hi,

maybe this:

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

Highlighted
Honored Contributor

Re: Number of Months

May be this?

=num(Month(today()))

Partner
Partner

Re: Number of Months

Hi,

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

Highlighted
New Contributor III

Re: Number of Months

Hi Mario,

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