Discussion board where members can get started with Qlik Sense.
I want to create a linegraph showing sales per category for multiple years.
Below a screenshot of the datatable and the linegraph
What I try to achieve is
- X-Axis : showing the months
- 3 line graphs with monthly-cumulative ticketsales (tol_quantity) figures
Now the data for the 3 series seems to be mixed in stead of nicely grouped per dimension
Here is the script
Year(to_date) as Year,
Month(to_date) as Month;
Date(Date#(to_date,'YYYY-MM-DD')) as to_date,
(ooxml, embedded labels, table is Sheet1);
Create a Line Chart
Hi Manish, please find attached the (qlik sense) app and the data.
The 2 graphs show the problem, being that the data sets over which the totals are calculated should be narrowed down, in order to only use and sum the data of the corresponding event
gwassenaar not sure, but this might be a no-brainer for you to answer. Issue is that the rangesum should be calculated per dimension. It now includes all data within a given set (including data points of another dimension). Appreciate your advice on this one.
Something that was as simple as checking a box in QV is so difficult in QS. Anyone got an answer for how to accumulate over 2 dimensions for this exact post?