Skip to main content

Official Support Articles

Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!

Qlik NPrinting PixelPerfect Stacked Lines Chart

cancel
Showing results for 
Search instead for 
Did you mean: 
Ruggero_Piccoli
Support
Support

Qlik NPrinting PixelPerfect Stacked Lines Chart

Suppose that you have a Qlik straight table with the columns Year, Month and sales like the following:

Sales by Year and month.png

and you want to obtain a PixelPerfect chart with a line for each year and details by month like the following:

Sonja_Bauernfeind_0-1650360077365.png

 

 

Environment:

Qlik NPrinting 

 

  1. Create a new PixelPerfect template (or open an existing one, as you prefer) and add the source table to the Tables node.

    Sonja_Bauernfeind_1-1650360206247.png

     

  2. Create a new PixelPerfect chart and select the type Line Stacked. Click on Next 2 times.

    Sonja_Bauernfeind_2-1650360224761.png

  3. Change the name of Serie 1 to 2014 and the name of Serie 2 to 2015. Click on Next.

    Sonja_Bauernfeind_3-1650360243818.png

     

  4. Select the Series Binding tab and click on 2014 (the first serie). Click on the three dots on the right of Data filter, the Data Filter Collection Editor will open. Click on Add.

    Sonja_Bauernfeind_4-1650360255020.png

     

  5. Expand the Column Name drop down menu and select the Year field to filter values of that field. In the Value form type 2014. The first serie will contain only values that satisfy this filter.

    Sonja_Bauernfeind_5-1650360269860.png

     

  6. Open the Argument drop-down menu and select the Month column.
  7. Open the Value drop-down menu and select the Sales column.

    Sonja_Bauernfeind_6-1650360287907.png

     

  8. Repeat the process for the 2015 series. Click on Point Labels on the left column.

    Sonja_Bauernfeind_7-1650360309143.png

     

  9. Remove the visible flag for both series.

    Sonja_Bauernfeind_8-1650360328161.png

     

  10. Click on Finish, if necessary adjust the chart dimensions and run a preview.
Labels (1)
Comments
woutermak
Partner - Creator III
Partner - Creator III

Nice. Is it also possible to use the max of year and the max of year -1 instead of static values?

Regards,
Wouter

Ruggero_Piccoli
Support
Support

No, it is not possible to insert a formula instead of a fixed value.

Lech_Miszkiewicz

Like i said - it is not possible to have 2 dimensions which in this case is a main factor.

My suggestion is more flexible as you can create measure for YEAR and measure for YEAR -1 in Qlik and have them dynamic on Qlik side.

Other steps would be similar to Ruggero's with only difference that in my solution you do not have to apply filters in PixelPerfect charts as they will be already filtered by set analysis expression.

regards

Lech

PS. Ruggero - do you thinkg you could ask R&D to consider building multidimensional charts in Pixel Perfect (as a feature request)?  That would apply to multidimensional bar charts or stacked bar charts with dynamic stacks etc

Ruggero_Piccoli
Support
Support

Of course, I can ask!

woutermak
Partner - Creator III
Partner - Creator III

Good Idea to make two measures. But you also have static names for the series.
The use of variables would be nice
Wouter

Hatus
Partner - Creator II
Partner - Creator II

Thanks for the article and alternative solutions! I also work with set analysis in Qlik for the single expressions. The major problem in both solutions is the name displayed in the legend. It's not dynamic.

@Lech_Miszkiewicz @Ruggero_Piccoli 

Is there a solution for displaying the field value in the legend?

 

Thank you so much.

Ruggero_Piccoli
Support
Support

Hi,

Your request is not clear to me. Legend is for the categories of data so you see the category names there. 

Maybe you need to use Point Labels to add the values of the point in the chart.

Let me know if this helps.

Best Regards,

Ruggero

Hatus
Partner - Creator II
Partner - Creator II

Thanks for answering!

 

In the first screen shot we can set an expression for the label.

Anmerkung 2019-10-31 102718.png

This variabel displays in this case the name of the 5 portfolios selected simulating a second dimention with set analysis.

Anmerkung 2019-10-31 102638.png

 

In the PixelPerfect Template we can set only a fixed name for the series for the same chart comming from Qlik for each expression.Anmerkung 2019-10-31 094800.png

The final result is shown below. The legend shows only the fixed names like in the series but not the result of the expressions like in the original Qlik Sense chart.

Anmerkung 2019-10-31 094837.png

Is there a way to display the names of the expressions in PxP with an expression or variable?

Can we overwrite the labels with a script where we can lookup for the variable results?

 

Thanks for your reply!

Version history
Last update:
‎2022-04-19 05:26 AM
Updated by: