Need some logic/formula to apply in Qlikview NPrinting

[#1]

I need to add current month values and i used the formula month(now()) in filter in NSQ file. I want to add YTD data(from May 2016 to May 2017). How I can create a filter which will display the values of YTD and each and every month it needs to be added with the current month data from May 2016.

If I use month(now())-1 then it will display only the current month and the previous month data. Can you please help me to derive some logic for the same in NPrinting Filter.

[#2]

because in NPrinting it is bit different and if I use some logic for data which is not available then I'm not getting the desired output in my excel as well.

Please help me to sort this issue.

[avinashelite]

Create a set analysis expression in Qlikview to select the data range and use the same in NPrinting .

NPrinting has the capability to evaluate the expression which is working in the Qlikview.

check this

filter in Nprinting

[#4]

I couldn't achieve the results. Can you please help me with examples

[Daniel_Jenkins]

Hi Vinu,

If you upload a simple QVW file and a mockup of what result you want, I'm sure your requirement will be much clearer and someone will assist.

Best,

Daniel.

[#6]

The issue resolved by creating the requirements in QVW file itself and then its achieved straight forward in NPrinting

[avinashelite]

If you have got the answer please mark the correct and helpful answers and close this thread