Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i would like to create a line stacked chart by Nprinting having two dimension as: month(data_field) and year(data_field)
As expression: sum(Sales)
I can display only one line and i would differents lines for each year
The aspetted result would be similar as this (image attached)
Any suggestios?
thank you
I wrote a step by steo tutorial about how to create a line stacked chart in PixelPerfect PixelPerfect Stacked Lines Chart
Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.
Hi Federico,
if you are exporting to Excel you can use the Pivot chart functionality to get this chart.
BR,
Matus
Yes but i must to insert it in a Pixel Report template. It's the same?
Sorry, I am not using pixelperfect but I think it is completelly different.
BR,
Matus
Hi
You cannot add multiple dimension in PixelPerfect Chart.
As an alternative you can build (using for example set analysis) dedicated measures for each year - I know that it is not ideal solution, but currently there is not other option.
Then you can add one dimension (month) and multiple line series (each representing differnet year)
hope this helps
regards
Lech
In PixelPerfect you can create a stacked lines chart.
I'm wrinting the instructions.
I wrote a step by steo tutorial about how to create a line stacked chart in PixelPerfect PixelPerfect Stacked Lines Chart
Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.