topic Set Analysis in nested what if expression in QlikView

Set Analysis in nested what if expression

Wed, 19 May 2010 15:51:11 GMT

I'm trying to translate this if, then, else construction to a set analysis expression..

SUM(if(Column1=[vValue] and Column2=1 AND Column3=0 and YEAR(Today)-2
, if(Colomn4='C' or Colomn4='VV' and YEAR(Today)-2, SALES*(-1)
, SALES)))/1000

This is what I have now but it's not working :(...

if(Column1=[vValue] AND Column2=1 AND Column3=0,sum({<YEAR(today)-2>}SALES*(-1)),
if(Column4='A' OR Column4='B',sum({<YEAR(today)-2>}SALES*(-1)),
SALES))/1000

can someone help me out :-))?

Set Analysis in nested what if expression

Wed, 19 May 2010 18:36:37 GMT

Looks rather complex, can you "devide and conquer"

Use a straight table and do the evaluations one by one, then start to concat and post the one that does not work?

Good luck

Juerg

Set Analysis in nested what if expression

Thu, 20 May 2010 08:01:01 GMT

I will try that approach 🙂 thanks!