topic Re: cumulative sum in line chart in App Development

cumulative sum in line chart

Sun, 15 Nov 2015 09:40:10 GMT

Hello

I have an expression I need to show in a line chart this way ( i have two dimensions, country and time (hierarchy Month->day->hour)

The cumul has to be 100% at all times

and with the expression (sum(flag)/sum(total flag))

The cumul is bellow 100% how can I make it 100% at all times

Thanks

Re: cumulative sum in line chart

Chanty4u — Sun, 15 Nov 2015 10:46:18 GMT

post sample qvw?

Re: cumulative sum in line chart

Sun, 15 Nov 2015 17:14:02 GMT

hello

figured it out the answers is

sum(sales)/sum(Total<Month,Day,hour> sales)

Re: cumulative sum in line chart

rwunderlich — Sun, 15 Nov 2015 18:38:46 GMT

You will need to include the Dimension fieldname in TOTAL to get 100% per interval. Because you are using a Drill group, use a $() to insert the correct fieldname.

sum(flag) / Sum(TOTAL <$(=GetCurrentField(TimeGroup))> flag)

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: cumulative sum in line chart

rwunderlich — Sun, 15 Nov 2015 18:43:31 GMT

That looks like easier syntax than my solution

-Rob

Re: cumulative sum in line chart

Mon, 16 Nov 2015 12:35:27 GMT

Hello Rob,

actually there is no GetCurrentField() in Qliksense which could have been really helpful for many other developments.

Thanks for your answer