Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

sfatoux72
Valued Contributor

NPrinting Excel reporting with a loop on several sheet

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

6 Replies

Re: NPrinting Excel reporting with a loop on several sheet

Hi,

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

Refer this documents

sfatoux72
Valued Contributor

Re: NPrinting Excel reporting with a loop on several sheet

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.

ganeshreddy
Contributor III

Re: NPrinting Excel reporting with a loop on several sheet

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

sfatoux72
Valued Contributor

Re: NPrinting Excel reporting with a loop on several sheet

Hi Ganesh,

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

Thanks

ganeshreddy
Contributor III

Re: NPrinting Excel reporting with a loop on several sheet

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

sfatoux72
Valued Contributor

Re: NPrinting Excel reporting with a loop on several sheet

Thanks, I will see this video

Best regards,

Sébastien

Community Browser