Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
edwinwitvoet
Not applicable

Cumulative linegraph with multiple dimensions

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

ticketorder_per_month_per_year.png

9 Replies
MK_QSL
Not applicable

Re: Cumulative linegraph with multiple dimensions

Like this?

edwinwitvoet
Not applicable

Re: Cumulative linegraph with multiple dimensions

Thanks Manish. I am using Qlik Sense. Is it possible for you to share a qlik sense  example / file?

MK_QSL
Not applicable

Re: Cumulative linegraph with multiple dimensions

Ok..

Here is the script

Load

  *,

  Year(to_date) as Year,

  Month(to_date) as Month;

LOAD tol_id,

     Date(Date#(to_date,'YYYY-MM-DD')) as to_date,

     event,

     tol_quantity

FROM

(ooxml, embedded labels, table is Sheet1);

Create a Line Chart

Dimension

Month

Year

Expression

rangesum(above(TOTAL sum(tol_quantity),0,rowno(TOTAL)))

edwinwitvoet
Not applicable

Re: Cumulative linegraph with multiple dimensions

Thanks a lot Manish.

After doublechecking, the lines do not show the correct totals

Note I added 'event' as a second dimension

download.png

MK_QSL
Not applicable

Re: Cumulative linegraph with multiple dimensions

Kindly close the thread by selecting correct answer..

MK_QSL
Not applicable

Re: Cumulative linegraph with multiple dimensions

Provide sample data to work.. I will check and update you.

edwinwitvoet
Not applicable

Re: Cumulative linegraph with multiple dimensions

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

edwinwitvoet
Not applicable

Re: Cumulative linegraph with multiple dimensions

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.

adjrockadjrock
Not applicable

Re: Cumulative linegraph with multiple dimensions

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?