topic Re: Help With RangeSum in QlikView

Help With RangeSum

Thu, 02 Jul 2015 12:40:01 GMT

I am using a RangeSum to calculate the accumalative count of model key in an expression over Months as dimension

RangeSum(Above(Count({$<outage_type={0}>} distinct model_key), 0, RowNo()))

This expression shows me accumulative count of the model key over months in line chart . but when i am selecting the values of only a month in the chart it shows count of model key only associated with the given selection. and does not show me the same count as it was showing in the trend chart by selecting only year

in this example 17 was the no of model key for May as accumulative no but shows only 13 on double clicking the value in chart for month of May . I want same value even when selecting the month

Please refer the attached

Re: Help With RangeSum

Gysbert_Wassenaar — Thu, 02 Jul 2015 12:43:33 GMT

See this document: Calculating rolling n-period totals, averages or other aggregations

Re: Help With RangeSum

sunny_talwar — Thu, 02 Jul 2015 12:44:02 GMT

Try this:

=If(Count({$<outage_type={0}>} distinct model_key) > 0, RangeSum(Above(Count({$<outage_type={0}, Month = >} distinct model_key), 0, RowNo()))

Add Month and all other calendar object where you can make a potential selection in your RangeSum expression Above (Month =, MonthYear = , Year = , Week = and so on)

HTH

Best,

Sunny

Re: Help With RangeSum

Thu, 02 Jul 2015 12:52:19 GMT

I added Year=, Month=,and Day= in expression , still when i click the value on chart it showing same 13

But with the above suggestion , this is showing fine when i am selecting the Month from calendar

Re: Help With RangeSum

sunny_talwar — Thu, 02 Jul 2015 12:53:47 GMT

What is your dimension on the chart? Did you add that to the expression also?

Re: Help With RangeSum

Thu, 02 Jul 2015 13:01:02 GMT

Thanks it worked after adding the dimesion

Re: Help With RangeSum

sunny_talwar — Thu, 02 Jul 2015 13:02:05 GMT

Awesome

I am glad it worked.

Best,

Sunny

Re: Help With RangeSum

Fri, 03 Jul 2015 04:40:00 GMT

Thanks .. but one more help

i want to start the count for june from 17 onwards but if use the above expression it starts 1st june count only

For example in my current example , Till may 31st the accumulative count of model key is 17, but when i select June then it should also consider 17 and start from there onwards

Re: Help With RangeSum

sunny_talwar — Fri, 03 Jul 2015 05:44:03 GMT

‌According to my understanding the expression should handle the June selection, but if it is not able to handle it then I would have to take a look at it. Would you be able to share a sample?

Re: Help With RangeSum

Mon, 06 Jul 2015 10:01:53 GMT

No June Selection is not handling the expression its giving the no of outage type 0 model key added from 1st June

Any suggesstion

Re: Help With RangeSum

sunny_talwar — Mon, 06 Jul 2015 10:04:55 GMT

Would you be able to share a sample?