topic Re: How to write a set analysis expression using a range of date? in QlikView

How to write a set analysis expression using a range of date?

Fri, 28 Sep 2012 18:58:29 GMT

Hi all,

I want to write a set analysis expression that could count a number of client between 2 fiscal year.

I tried this :

sum({$<FiscaleYear={'>=2010'}, FiscaleYear={'<=2012'}>} NumberClient)

but it sums all the client before 2013 and all the client after 2009.

What I want is the number of client between 2010 and 2012.

Do you have any ideas?

Many thanks

v_iyyappan — Fri, 28 Sep 2012 19:22:48 GMT

Hi,

Try like this

Sum({<FiscaleYear={>=(2010))<=(2012)}>} NumberClient)

Iyyappan

Fri, 28 Sep 2012 19:25:55 GMT

Yes it is working, I just remove a ')'

Sum({<FiscaleYear={>=(2010)<=(2012)}>} NumberClient)

Thank you