Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have to developed monthly reports which contains YTD also as well as some monthly data for some reports.
So I need selection on months while generating report.
i.e. For Month of July Reports : I have created one variable $(vMonth) where I add values manually MAR,APR,MAY,JUN
because if I add vMAXMonth it will only fetch max month of Jun.
Is there any way to automate this process? with required range.
Note: We run this report to get data range till last month.
Please check this
How to Set a QlikView Variable to a Specific Value Using Filters
Hi Mandar,
The tutorial How to Set a QlikView Variable to a Specific Value Using Filters is correct but related to NPrinting 16.* ord older versions. This feature is not yet available in NPrinting 17.*.
If you are using NPritning 17 you can create a filter like the one you can see in the attache image:
- add the field "Year", set Evaluate value from the drop down menu and insert the formula =year(now()) (adapt the formula to your needs)
- add the field "Month", set Evaluate value from the drop down menu and insert the formula =month(now())
- add more "Month" evaluate values with formulas =month(now())-1, =month(now())-2, ... =month(now())-11
The selection on the Year keep only records related to the current year so months from previous year are not selected.
I hope this helps.