Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have Qlik Nprinting (May 2021 SR2 Version: 21.14.5.0)
I want to make a report per week, so each sheet has a separate week number, and in there is a pivot table with data for that week.
Sheet per week I make by levles -> its ok
after:
I make a pivot table based on a normal table from Qlik -> its ok
My table is made like this, unfortunately after refreshing, it is not consistent with the expected result, I wanted the weekend number to be in B1.
How can I fix it?
before
after
@Sebastian_Dec as you likely already are aware, that version is well out of support.
Its best to build your pivot table in QlikSense, then import as image:
I agree with @David_Friend that the easiest would be to use image however it is indeed terrible practice and rather poor/limiting result so to me using image is only if nothing else worked.
Now I have quite few doubts about the way you are building it:
Do not expect that you will get pivot table prefiltered based on the level or variable or formula from NPrinting - that will not work and it is actually Excel limitation.
You can PM me and I can take you through it if you have any issues.
Cheers
Lech
@David_Friend Thank you for your answer, we will try to update the program in the new year.
@Lech_Miszkiewicz Thanks a lot for your help, we will be testing the new solution this week, I will try to give you an answer by Friday.
Hi,
Upgrading to a supported version is strongly suggested but will not solve.
To create a different worksheet you have to use Pages, not Levels. Native Excel pivot tables works with Pages (refer to the release notes to see the minimum version that support this) but the source table must be in the same page of the pivot to be filtered by the field used to create the page.
You can hide the rows of the source table.
Native Excel pivot tables do not work inside levels.
Best Regards,
Ruggero