cumulative sum in line chart

[#1]

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

[Chanty4u]

post sample qvw?

[#3 · Accepted solution]

hello

figured it out   the answers is

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

[rwunderlich]

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

[rwunderlich]

That looks like easier syntax than my solution

-Rob

[#6]

Hello Rob,

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

Thanks for your answer