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
post sample qvw?
figured it out the answers is
That looks like easier syntax than my solution
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)
actually there is no GetCurrentField() in Qliksense which could have been really helpful for many other developments.
Thanks for your answer
Retrieving data ...