Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

YTD monthly expression not working in SR6, works in SR2

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

2 Replies

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

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?


talk is cheap, supply exceeds demand
Not applicable

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

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.

Community Browser