topic Re: NPrinting Excel reporting with a loop on several sheet in Qlik NPrinting

NPrinting Excel reporting with a loop on several sheet

sfatoux72 — Thu, 11 Jun 2015 09:57:50 GMT

Hi,

I have three sheet "Country - Actual", "Country - Previous", "Country - Delta" in my Excel template.

I want to loop on the Country dimension to generate a report with these sheets (in this order) :
"Italy - Actual", "Italy - Previous", "Italy - Delta", "France - Actual", "France - Previous", "France - Delta", ...

At this time, I added Coutry dimension as Page, but I get the following resut:

"Italy - Actual", "France - Actual", ... , "Italy - Previous", "France - Previous", ... , "Italy - Delta", "France - Delta", ...

Is it possible to get the result that I want ?

Many thanks,

Sébastien

Re: NPrinting Excel reporting with a loop on several sheet

avinashelite — Thu, 11 Jun 2015 10:01:37 GMT

Hi,

Use Cyclic grouping in the NPrinting and will give you the desired result .

Refer this documents

Re: NPrinting Excel reporting with a loop on several sheet

sfatoux72 — Thu, 11 Jun 2015 10:33:39 GMT

That is not what I need.

Cyclic grouping in NPrinting will give one report per Country, but I want only one report with all countries.

Re: NPrinting Excel reporting with a loop on several sheet

ganeshreddy — Thu, 11 Jun 2015 10:39:07 GMT

Hi Fatoux,

Use link filter option in Nprinting , it provides synchronizing option as well . It gives you result like below mentioned.

"Italy - Actual" , "Italy - Previous", "Italy - Delta", ...

Cheers,

Ganesh

Re: NPrinting Excel reporting with a loop on several sheet

sfatoux72 — Thu, 11 Jun 2015 11:23:02 GMT

Hi Ganesh,

Where can I find "link filter option"? I did'nt find it in the NPrinting help

Thanks

Re: NPrinting Excel reporting with a loop on several sheet

ganeshreddy — Thu, 11 Jun 2015 12:16:32 GMT

Hi Fatoux,

Please go through this video, you will get answer for your question. Unfortunately it is a long video file, i can not give you the exact time stamp on it . But i am sure will help you .

NPrinting Basic Technical Training Video 10-02-2014 - YouTube

Cheers,

Ganesh

Re: NPrinting Excel reporting with a loop on several sheet

sfatoux72 — Thu, 11 Jun 2015 15:57:03 GMT

Thanks, I will see this video

Best regards,

Sébastien