Qlik Community

Qlik NPrinting Documents

Documents related to Qlik NPrinting.

PixelPerfect Stacked Lines Chart

Employee
Employee

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:

PxP 2 dim chart.png

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

030.png

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

040.png

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

050.png

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.

060.png

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.

070.png

Open the Argument drop down menu and select the Month column.

Open the Value drop down menu and select the Sales column.

080.png

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

090.png

Remove the visible flag for both series.

100.png

Click on Finish, if necessary adjust the chart dimensions and run a preview.

Labels (1)
Comments
woutermak
Contributor III

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

Regards,
Wouter

Employee
Employee

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

Lech_Miszkiewicz
Honored Contributor III

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

Employee
Employee

Of course, I can ask!

woutermak
Contributor III

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

Version history
Revision #:
1 of 1
Last update:
‎09-25-2017 09:31 AM
Updated by: