topic Re: Qlik NPrinting OnDemand (xlsx) selected date minus one year in Qlik NPrinting

Qlik NPrinting OnDemand (xlsx) selected date minus one year

georgwildmoser — Thu, 30 Jan 2020 15:08:45 GMT

Hi,

I am stuck right now. I create a OnDemand-Report based on QlikView. The report contains two simple pivot tables. The result of the first pivot table should take into account the filtered day of the user at the access point. Thats working.

Here is my problem: The result of the second pivot table should take into account the filtered day of the user at the access point minus one year.

For this I created a variable vCSDATEVJ in QlikView with the formula "=num(AddYears(max(DATE),-1)) " (DATE is numeric) and added a filter in NPrinting with field DATE and value =$(vCSDATEVJ) and option overwrite worth. The Filter is added to the object.

When I run the onDemand, the second pivot table is not displayed. Where is my mistake?

Thanks in advance for the help.

Re: Qlik NPrinting OnDemand (xlsx) selected date minus one year

Lech_Miszkiewicz — Fri, 31 Jan 2020 06:44:02 GMT

this is not how you should design it.

I suggest you create another Pivot table object in your QlikView which will have "set analysis"expression respecting the -1 year selection and use this second object as a source of for your second pivot table in NPrinting.

Cheers

Lech

Re: Qlik NPrinting OnDemand (xlsx) selected date minus one year

georgwildmoser — Fri, 31 Jan 2020 08:28:08 GMT

Yes, I just wanted to use an object for this. The object already exists and the time is actually just a filter. But I'll probably do it exactly as you suggested. Thanks for your feedback.