topic Re: Set analysis expression in QlikView

Set analysis expression

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All

I have a cyclic dimenssion (year ,month, Quater ) and i had return the expression as follows

=sum({<Test4-={0}>}Test4)+1 .By this i am getting the output as expected .

But the problem is for month and year we have dates up to 2020. and Test4 data is up to current month .

By adding +1 in the expression my chart shows value 1 in the chart from 2017 Feb to end of 2020.

I want restrict that and i want to show it beyond current month i.e FEB 2017 that +1 values

(Note: I want to do in the expression )

Can please advice me .

sushil353 — Thu, 19 Jan 2017 05:22:45 GMT

Hi,

I think you are checking null/zero values in Test4, so for in case of cyclic dimension try to use if condition

if( isnull(Test4),sum(Test4),sum(Test4)+1)

HTH

Sushil

varshavig12 — Thu, 19 Jan 2017 05:32:03 GMT

Try this:

=sum({<Test4-={0,''}>}Test4)+1