Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
sims
Contributor II
Contributor II

How to create a combo chart with daily registration and cumulative

sims_0-1623273582772.png

Hi everyone 

I am new to Qlik sense need your help with creating this chart. The chart above is created in excel but want to replicate the same in Qlik sense. The dimensions are daily registration dates on the X-axis but labels shown as months and the yellow line is the cumulative registration date. The primary Y-axis is the count of registration date per day and the secondary Y-axis represents the cumulative. The data looks like this:

DateCount of RegiDateCount of RegiDate2
2019-12-1422
2019-12-16911
2019-12-171627
2019-12-181946
2019-12-191056
2019-12-20763
2019-12-21265
2019-12-23267
2019-12-24774
2019-12-26680
2019-12-27484
2019-12-28892
2019-12-30395
2020-01-0213108
2020-01-0324132
2020-01-044136
2020-01-053139
2020-01-067146

 

1 Solution

Accepted Solutions
Sammy_AK
Creator II
Creator II

drag and drop the combo chart into qlik canvas. in the visualization component, select dimension as date and in Measure 1: input sum(Count of RegiDate) and in another measure 2: sum(Count of RegiDate 2).

if you want to generate cumulative count in Qlik Sense, you can use the below expression 

RangeSum(Above(TOTAL count(Count of RegiDate), 1, RowNo(TOTAL)))

View solution in original post

1 Reply
Sammy_AK
Creator II
Creator II

drag and drop the combo chart into qlik canvas. in the visualization component, select dimension as date and in Measure 1: input sum(Count of RegiDate) and in another measure 2: sum(Count of RegiDate 2).

if you want to generate cumulative count in Qlik Sense, you can use the below expression 

RangeSum(Above(TOTAL count(Count of RegiDate), 1, RowNo(TOTAL)))