topic Re: YTD monthly expression not working in SR6, works in SR2 in QlikView

YTD monthly expression not working in SR6, works in SR2

Fri, 20 Mar 2015 19:42:21 GMT

Hi,

I have a requirement, where i want to show YTD monthly accumulation in bar chart.

e.g- If i select month as Jan, i should see all values for the measure for jan, if i select feb, it should be accumulation of jan & feb.

In the same bar chart i should see both jan & feb trend.

I used the below expression.

Rangesum(above(sum({<[Month]={'<=$(=max([Month]))'}>}[Sales Triggered]),0)) with full accumulation in expression.

My dimensions are 'Sales Month' and another cyclic group with 'Country' & 'Continent'.

For one country, the Sales Triggered value is 0 for Feb month but for jan it's 5. So i should see 5 in jan & 5 in Feb also (5+0=5)

Strange is that it's working fine in SR2 QV11 but not in SR6/SR8.

Please help on this.

Thanks in advance

Re: YTD monthly expression not working in SR6, works in SR2

Gysbert_Wassenaar — Sat, 21 Mar 2015 08:46:48 GMT

Rangesum(above(sum({<[Month]={'<=$(=max([Month]))'}>}[Sales Triggered]),0))

above( ..., 0) doesn't actually do anything. Your expression is equivalent to sum({<[Month]={'<=$(=max([Month]))'}>}[Sales Triggered])

Can you post a qlikview document that demonstrates the problem?

Re: YTD monthly expression not working in SR6, works in SR2

Sun, 22 Mar 2015 09:32:19 GMT

Thanks for the reply Gysbert.

Whenever for a month if a country value is 0, then i dont see the accumulation for the below expression. So i used Rangesum(Above(...0,) which works fine in Local though but not in access point. Server is having SR6 version installed but my local is having SR2 installed.

sum({<[Month]={'<=$(=max([Month]))'}>}[Sales Triggered])

I'll try to post a sample file for the same scenario.

Thanks.