topic Re: Ruuning Average Issue in QlikView

Ruuning Average Issue

Thu, 14 Apr 2016 04:30:28 GMT

I have qvw that has chart which shown running average of last 13 month. Soon I pick a year in selection, I expect running average should still be intact but only that years shows up with values. Somehow X-Axis shows weird order and latest months show up in between which messes up running average as well.. Please see qvw attached and screenshot with no selections and with selection

Now When I select Year 2015, It brings wrong order in x-Axis as shown below which messes up running average. PLEASE HELP

Re: Ruuning Average Issue

perumal_41 — Thu, 14 Apr 2016 05:03:43 GMT

do you need only 2015 years data , then remaining all zero values are suppressed .

like below

Re: Ruuning Average Issue

sujeetsingh — Thu, 14 Apr 2016 05:10:40 GMT

Faisal either supress zero or missing (nulls) else assign zero to nulls or missing.

Re: Ruuning Average Issue

Gysbert_Wassenaar — Thu, 14 Apr 2016 06:10:53 GMT

If you want to see only the selected period then wrap the unaggregated strings in the five info expressions in an Only() function:

old: ='CalYear/Month = '&[CalYear/Month]

new: =Only('CalYear/Month = ') &[CalYear/Month]

Your CalYear/Month field contains only text values. Those cannot be sorted numerically. You can sort by an expression like only({1}CalKey). Or better create CalYear/Month as a dual field: Date(MonthStart(MyDate),'MMM YYYY') as [CalYear/Month]

See attached qvw.

Re: Ruuning Average Issue

Thu, 14 Apr 2016 10:21:02 GMT

Thanks.. It seems they are sorted properly and also running average for 36 months is calculated correctly. I wanted to know how this work. Why info expressions were messing up running calculations and order in X-Axis