topic Re: NPrinting Powerpoint nested page in Qlik NPrinting

NPrinting Powerpoint nested page

boopeshj — Sat, 16 Nov 2024 04:25:05 GMT

Hey NPrinting experts CHALLENGE here . Is this possible ?

I would like to generate a PPT with nested dimension split. There are 2 dimesion. First the slides should be populated on dimension 1 and split for all 3 values of dimension 2. And continue according to the representation .

Slide 1 > Dim 1_value 1 > Dim 2 _Value 1

Slide 2 > Dim 1_value 1 > Dim 2 _Value 2

Slide 3 > Dim 1_value 1 > Dim 2 _Value 3

Slide 4 > Dim 1_value 2 > Dim 2 _Value 1

Slide 5 > Dim 1_value 2 > Dim 2 _Value 2

Slide 6 > Dim 1_value 2 > Dim 2 _Value 3

Expecting some expert help 🙂

Re: NPrinting Powerpoint nested page

Lech_Miszkiewicz — Tue, 19 Feb 2019 07:00:42 GMT

Hi - this was already discussed on community on multiple occasions.

It is possible! The most appriopriate instructions how to achieve this are under this link:

https://community.qlik.com/t5/Qlik-NPrinting-Documents/How-to-Use-Pages-to-Generate-Individual-Slides-in-PowerPoint-for/ta-p/1481268

cheers

Re: NPrinting Powerpoint nested page

boopeshj — Tue, 19 Feb 2019 08:03:13 GMT

Thanks a lot will check this.
" How to Use Pages to Generate Individual Slides in PowerPoint for Each Combination of Multiple Field Values "

Re: NPrinting Powerpoint nested page

boopeshj — Tue, 08 Oct 2019 08:52:20 GMT

Thanks @Lech_Miszkiewicz

May be I missed something . Please find the exact example I am looking for.

Slide 1 > Dim 1_value 1

Slide 2 > Dim 1_value 1 > Dim 2 _Value 1

Slide 3 > Dim 1_value 1 > Dim 2 _Value 2

Slide 4 > Dim 1_value 1 > Dim 2 _Value 3

Slide 5 > Dim 1_value 2

Slide 6 > Dim 1_value 2 > Dim 2 _Value 1

Slide 7 > Dim 1_value 2 > Dim 2 _Value 2

Slide 8 > Dim 1_value 2 > Dim 2 _Value 3

Re: NPrinting Powerpoint nested page

Lech_Miszkiewicz — Tue, 08 Oct 2019 09:28:29 GMT

This seems straight forward to me - maybe i am missing something - It is actually Qlik data modeling question and not really nprinting question as all needs to be done in Qlik data model.

All what you need to do is create an additional dimension: Dim 2 Bridge which will also include TOTAL value for all dim 2 values

so currently your Dim 2 has Value 1, Value 2 and Value 3

What you need is to create a bridging table like this:

Dim 2, Dim 2 Bridge

Value 1, Value 1

Value2, Value2

Value3, Value3

Value 1, Total

Value2, Total

Value3, Total

Once you have this bridging dimension created in your Qlik model you need to use it to build Qlik table with dimensions:

Dim1 and Dim 2 Bridge and use this Qlik table in your page tag. Effectively you still have page running over 2 dimensions but in each value for dim 1 you always include TOTAL for dim 2 imitating no selection on dim 2

so your layout would look like:

Slide 1 > Dim 1_value 1 > Dim 2 _TOTAL

Slide 2 > Dim 1_value 1 > Dim 2 _Value 1

Slide 3 > Dim 1_value 1 > Dim 2 _Value 2

Slide 4 > Dim 1_value 1 > Dim 2 _Value 3

Slide 5 > Dim 1_value 2 >> Dim 2 _TOTAL

Slide 6 > Dim 1_value 2 > Dim 2 _Value 1

Slide 7 > Dim 1_value 2 > Dim 2 _Value 2

Slide 8 > Dim 1_value 2 > Dim 2 _Value 3

Re: NPrinting Powerpoint nested page

boopeshj — Fri, 25 Oct 2019 10:32:22 GMT

Thanks Lech.

Maybe i missed this point. Slide format for the followign are different.

Slide 1 > Dim 1_value 1

Slide 2 > Dim 1_value 1 > Dim 2 _Value 1

First is more like a Title Slide.

Example : USA [Slide 1 > Dim 1_value 1 ]

Second is like a details slide

Example : Texas [Slide 2 > Dim 1_value 1 > Dim 2 _Value 1]

In the second slide you will have a table.

Let me know if this added information helps in identifying this as Nprinting problem. [Maybe along with Qlikview. ]

Re: NPrinting Powerpoint nested page

Lech_Miszkiewicz — Sat, 26 Oct 2019 00:25:21 GMT

Hi - this is different to the initial description hence obviously my answer will be different. Unfortunatelly I don't have a good news for you as in my opinion this is not possible to be fully automated.

Partial workaround you can see in this topic my last post. It is not ideal and so far it is the only way to achieve what yoy are trying to.

https://community.qlik.com/t5/Qlik-NPrinting-Discussions/NPrinting-Ppt-Utilizing-Pages-Questions/td-p/1294678

Maybe someone else has some other ideas, but from waht i can see in documentation there isn't one....