topic Re: unequal in QlikView

unequal

Thu, 02 Oct 2014 13:35:42 GMT

Hello,

i need your help!

how and where can i put a unequal condition like if(Value<>20824,) in this row

=SUM({<Year={'$(vMaxYear)'},TCMSALESORDERDATE={'<=$(vMaxDate)'},Month=,Day=,MonthYear=>} SALESPRICE*QTYORDERED)/1000

thanx

Anonymous — Thu, 02 Oct 2014 13:37:45 GMT

Try

Value-={20824}

Thu, 02 Oct 2014 14:11:07 GMT

i tried

=SUM({<Year={'$(vMaxYear)'},TCMSALESORDERDATE={'<=$(vMaxDate)'},Month=,Day=,MonthYear=>} if(Value<>20842,SALESPRICE*QTYORDERED))/1000

but there is no response

Anonymous — Thu, 02 Oct 2014 14:29:36 GMT

I thought you wanted this condition in set... Did you try it?
If you want "if", maybe you just need to add 0:

...

if(Value<>20842, ..., 0))/1000

Anonymous — Thu, 02 Oct 2014 14:29:52 GMT

Hi!

you can try

=if(Value<>'20824',SUM({<Year={'$(vMaxYear)'},TCMSALESORDERDATE={'<=$(vMaxDate)'},Month=,Day=,MonthYear=>} SALESPRICE*QTYORDERED)/1000)