topic Re: Set analysis with 'between' operator ? in QlikView

Set analysis with 'between' operator ?

dvasseur — Mon, 28 Jan 2013 10:27:19 GMT

Hello,

I have the following set analysis for Year 2013

sum({<Cust={"=Sum({1<Year={2012}>} Val) <= 20"}>} Val)

But I also have to include another filter for Sum({1<Year={2012}>} Val) >= 15"}>}

So, something like this:

sum({<Cust={"=Sum({1<Year={2012}>} Val) between 15 and 20"}>} Val)

which is of course not working

I could use 2 expressions but is there a better and nicer way in only one expression ?

Regards,

David

gandalfgray — Mon, 28 Jan 2013 11:02:39 GMT

Try

sum({<Cust={"=Sum({1<Year={2012}>} Val) >=15 <=20"}>} Val)

//GG

dvasseur — Mon, 28 Jan 2013 11:10:28 GMT

Hi Gandalf,

I already tried this, it's not working

Thx anyway !

David

sreenivas — Mon, 28 Jan 2013 11:23:01 GMT

sum({<Year={2012},Val={">=15<=20"}>}Val)

Mon, 28 Jan 2013 11:59:55 GMT

Hi ,

sum( {$<Cust = {"=Sum({1<Year = {2012}>} Val ) >= 15 and Sum({1<Year = {2012}>} Val ) <= 20"}>} Val )

Please check the Attached App..

Hope it helps you..

dvasseur — Mon, 28 Jan 2013 12:14:14 GMT

Hi bhaskar,

I thought I tried that but I should have missed something because, indeed, it's working, thanks !

David

francoiscave — Mon, 28 Jan 2013 13:25:12 GMT

Hi Dave,

Another solution :

sum({<Cust={"=Sum({1<Year={2012}>} Val) <= 20"}> * <Cust={"=Sum({1<Year={2012}>} Val) > 15"} > } Val)

Best regards,

François