Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello guys,
I'm with some troubles to create filters in Nprinting 17 reports.
I'm with a request to build a report with some data restrictions:
Data starts at August'2017 until my last month (In case, June'2018)
I tried this instructions from Nprinting help:
"You can use QlikView and Qlik Sense formulas to calculate values to be used in filters. Each formula must return a single value, and use QlikView or Qlik Sense syntax. For example, you can use a formula to calculate the value of the previous year and compare it with the Year field in a filter.
Do the following:
And for some cases it worked, but when I try to restrict months, It doesn't works.
For example, file in attach some example that works :
Anyone can help me with this?
Thank you!
this is because of "duality of the values"
Months are dual values (1|Jan, 2|Feb... etc) number|text
for dual values you need to evaluate values to numbers!
so if you want filter current month you would use =num(Month(Today()))
i have written quite a lot of instructions regarding this on community - use search and lookup already answered the same questions
cheers
Lech
examples:
Re: NPrinting doesn't apply evaluate filter
Re: Nprinting Filters not working on Excel Documents