Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Uploads getting stuck in the virus scanner. We are investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

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
Highlighted

Hi,

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

Refer this documents

Highlighted
Partner
Partner

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.

Highlighted
Creator III
Creator III

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

Highlighted
Partner
Partner

Hi Ganesh,

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

Thanks

Highlighted
Creator III
Creator III

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

Highlighted
Partner
Partner

Thanks, I will see this video

Best regards,

Sébastien