To apply filter on number of rows when creating PPT via NPrinting17
This is the first time that I am starting a discussion. So, here is my concern.
I want to build a PPT report via NPrinting17 for every value in Field SBU(Business Unit). I am fetching table in NPrinting and that is the straight table from Qlik Application. The requirement is to have 5 rows per Slide, I have created the report for each value but there is a problem that I am facing.
I added the same chart multiple times and applied CUSTOM ROWS for 1-5, 6-10 and 11-15 etc. I want the slides to be dynamic, the number of slides should be according to the number of rows but where there is the number of rows less than 15 or 10 then still there are slides being made for that (Blank Slide as no data ).
What can be done to do this achieve this, I know there is a constraint when preparing PPT in NPrinting but as a customer of Qlik, I think this can be solved.
I think it can also be done if I create Multiple charts in my QV app then fetch it but o that also I am facing a bad time.
So any suggestion is welcome as I have to complete it by tomorrow morning.
Re: To apply filter on number of rows when creating PPT via NPrinting17
I have an idea - but i have not tested it yet.
In general i would have to check on backend how many rows or rather slides for each SBU you need and create a refernece table linked to SBU. For example:
If SBU "A" needs 2 slides we would create a referenece table with values:
If SBU "B" needs 3 slides we would create a referenece table with values:
The next step would be to create a chart in Qlik with rank function groupin for each SlideNo 5 rows. so when you select in SlideNo field value 1 it shows you top 5, if you select 2 it shows you 6-10 etc...
Then you could use SlideNo field as a PAGE object for your PowerPoint template in NPrinitng and actually i think it would work! since you would only get as many slides as you need for each BU
If i have more time to actually build a solution i will post it here.
cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.