topic Re: NPrinting-Looping through a field Values in Qlik NPrinting

NPrinting-Looping through a field Values

dthokal19 — Wed, 19 Nov 2014 12:46:59 GMT

Hi All,

I am trying to create a ppt report using NPrinting. The requirement is that i want to show a chart, filtered on the basis of different values in a Field. Chart outcome for every value in that field should be copied on a new sheet. So basically the report should loop through a field and create a single ppt with number of sheets equivalent to number of values in that field.

I tried using Cycle feature but it creates new ppt altogether for every value of that field.

Please help and let me know if the problem statement isn't clear.

Regards,

Deepak

Re: NPrinting-Looping through a field Values

Andrea_Ghirardello — Fri, 21 Nov 2014 08:58:36 GMT

Hi Deepak,

In order to obtain a single ppt report with different slides, one for each value of a specific field, you have to use the the page feature inside the template editor instead of the report cycle functionality.

With the page feature you can:

- create a different slide for each value of a field

see http://community.vizubi.com/knowledgebase/articles/261109

- create a different slide for each combination of multiple fields (e.g. using a tablebox)

see http://community.vizubi.com/knowledgebase/articles/346263

- create a different set of slides for each single value of a field or for each combination of multiple fields

see http://community.vizubi.com/knowledgebase/articles/403236

hope this helps.

Andrea

Re: NPrinting-Looping through a field Values

dthokal19 — Mon, 24 Nov 2014 10:00:07 GMT

Thank you Andrea! This worked perfectly for me.

Re: NPrinting-Looping through a field Values

dthokal19 — Mon, 24 Nov 2014 10:02:17 GMT

Thank you Nils for your reply. Yes, Andrea's solution worked for me.

Re: NPrinting-Looping through a field Values

Andrea_Ghirardello — Mon, 24 Nov 2014 10:10:55 GMT

Great.

I'm happy to hear that it worked.

Best,

Andrea

Re: NPrinting-Looping through a field Values

Anonymous — Mon, 24 Nov 2014 10:16:31 GMT

No problem,

Just trying to avoid NPrinting support on the Qlik site

Re: NPrinting-Looping through a field Values

Daniel_Jenkins — Fri, 03 Jul 2015 01:10:05 GMT

Correct answer provided so this discussion is now locked.