Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Nprinting excel native graph are always printing only based on first value in Level

Description:

I am trying to create a excel native graph in Nprinting

Scenario-1 : Without applying any level Designer screen:

 

 

Scenario-1 : Without applying any level Excel output screen:

S1OPT.png

 

there is no problem with Scenario-1

 

Scenario-2 : After applying level in Designer screen:

S2.png

 

Scenario-2 : Output

S2OPT.png

 

Here two graphs are generated but both graphs are referring only First Value in Level i.e. Automotive and Graph for the Value “B*********” was never generated .

 

Attached is the excel output 

Labels (1)
2 Replies
Highlighted
Support
Support

Re: Nprinting excel native graph are always printing only based on first value in Level

Hi @guruprem 

I tried to get this to work but since it is not possible to place 'levels' tags around an MS chart, this won't work. The MS chart doesn't take up specific cell values ie; A1 B1 C1 etc (it can be dragged like an image anywhere on the sheet and partially cover some cells only) so it can't be used in the manner you suggested.

MS chart with QV or QS data.PNG

However when enabling the 'year' dimension using the NP page feature, I did get a separate chart for each year value.

See attached.

Hope this helps...

 

We are just 'like' you & like to be liked when we provide a helpful answer and or when you press the 'Solution Accepted' button if an answer provided resolves your question or issue... Cheers!
Highlighted
Partner
Partner

Re: Nprinting excel native graph are always printing only based on first value in Level

Hi @Frank_S  ,

Thank you very much for the clear explanation and workaround.