This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion board where members can learn more about Qlik Sense App Development and Usage.
Hi all. Hopefully this is pretty straight forward.
So here is the script I have for my app:
True_Churn, Retention_Target, Date_Measure, Closing_Base, Opening_Base,
(Closing_Base - Opening_Base) as Flow
And here is my data table:
Each month I'm going to update the table with the previous month's data.
I want to product a combo bar/line graph showing each month's Flow number as the bars, with the cumulative month on month Flow as the line.
The basics are pretty, well, basic:
But how do I add a cumulative line graph to it please?
I have tried
if(Sum(if(year(Date_Measure)=2018, Flow,0))>0, rangesum( above( sum(if(year(Date_Measure) = 2018,Flow,0)),0,rowno())), null)
But it's returning a figure for Feb of 27,188 (no idea how it's got that) not the expected 3,884.
Hi - sorted. I had made it far too complicated. Just a straight
Has done it.
View solution in original post
can you attach some data ? 12 lines with 2 columns: Flow and Date_measure
As attached - it's my actual data. Thanks!