NPrinting Powerpoint nested page

[boopeshj]

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 🙂 

[Lech_Miszkiewicz]

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-Slide...

cheers

[boopeshj]

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

[boopeshj]

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

[Lech_Miszkiewicz]

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

[boopeshj]

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. ]

[Lech_Miszkiewicz]

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-...

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