topic Re: help in expression in QlikView

help in expression

ali_hijazi — Fri, 31 Jul 2015 08:07:35 GMT

Hello got the following combo chart

the blue bar is the count of versions created and the red one is the number of versions deactivated

the line is the difference between the 2 accumulated

now what I want is the following :

if the user selects 2004 then the line should display 28 currently I'm getting the following:

how can I get the previous six and show 28 instead of 22?

Please advise

Message was edited by: Ali Hijazi

Re: help in expression

Anonymous — Fri, 31 Jul 2015 08:11:00 GMT

Please elaborate on your question 'previous six and show 28 instead of 22?'

Re: help in expression

MayilVahanan — Fri, 31 Jul 2015 08:23:29 GMT

Hope it helps

Calculating rolling n-period totals, averages or other aggregations

Re: help in expression

Anonymous — Fri, 31 Jul 2015 08:25:43 GMT

if you are using the accumulation check box then there is nothing to accummulate as you only have 1 year selected

if you are accumulating by yourself you should check your formula

for the line it should look like

Count({<Youryearfield={'<=$(=Youryearfield)'}>}created-inactive)

Re: help in expression

Gysbert_Wassenaar — Fri, 31 Jul 2015 08:45:44 GMT

I'm guessing your cat chewed on that expression. You'll have to replace it with a cat-proof expression.

Given the amount of information you've given this guess of mine is as good as most other guesses posted above.

Re: help in expression

ali_hijazi — Fri, 31 Jul 2015 08:46:55 GMT

what is cat-proof expression?

Re: help in expression

Gysbert_Wassenaar — Fri, 31 Jul 2015 08:48:20 GMT

One that proofs that your cat can't chew it.

How about you tell us what expression you're using now for that line? Or better, post a qlikview document that demonstrates the problem. I'd expected you'd know to give that sort of information by now.... after four years of asking questions here.

Re: help in expression

ali_hijazi — Fri, 31 Jul 2015 08:48:43 GMT

user selects 2004

in 2004 the difference is 22

plus 6 of 2003 then the result should be 28 and not 22

Re: help in expression

antoniotiman — Fri, 31 Jul 2015 08:52:31 GMT

Hi,

try expression like

If(Year=Max(Year),RangeSum(Above(Sum({<Year=>} a)-Sum({<Year=>} b),0,RowNo())))

Re: help in expression

ali_hijazi — Fri, 31 Jul 2015 08:55:41 GMT

check Attached qvw