Qlik Sense Pivot table in Qlik N Printing as HTML Template

[prayag7239]

Hello,

I have an requirement in Qlik N Printing 20 for Pivot table used in HTML Template. Pivot table should be expanded upto filtered values only in HTML Template.

I have total 3 levels of hierarchy and i am filtering in level 1 and level 2 in N Printing 20 using filter.

I want Pivot table should be expanded upto level 2 only, level 3 should not be expanded(it should remains in collapsed format.)

Please find below Screenshot and attached file for your reference.

Looking forward for help on this requirement.

[JordyWegman]

Hi Prayag,

NPrinting and Qlik Sense Pivots are not a great match.. Does it need to be HTML?

My best suggestion would be to do this in Excel.. Not sure if that could solve your issue.

Jordy

Climber

[prayag7239]

Yes,Jordy I want it in HTML.. wanted to distribute in Email body.

[JordyWegman]

Okay, but you say that level 3 needs to be shut, why don't you just remove level 3?

Jordy

Climber

[prayag7239]

Sorry Jordan, I have total four level hierarchy needs to achieved the same.

While filtering at level 1 and 2 it should be in expanded(- symbol), for level 3 and 4 under level 1 and 2 should not be expanded it remains in collapsed format(+ symbol).

[prayag7239]

Please find attached file for your understanding.

Want same 

[JordyWegman]

Yes I get that, but removing the last level will also result in the same right? Only not with the + symbol, but you were never going to see this anyway. By removing it, it seems like you getting to your solution.

Jordy

Climber

[prayag7239]

No Jordy, the collapsed level 3 and 4 also should be seen in chart.

So for level 3 and  4 total values for both level should be shown in (+) collapsed format.

I.e. level 1 and 2 expanded based on filters while level 3 and 4 should be in collapsed format to show it's values.