topic Re: Set Analysis Problem in QlikView

Set Analysis Problem

Fri, 15 May 2015 11:27:34 GMT

Hello,

I am using IF condition but not able to use 'DOES NOT CONTAIN' i.e '<>' sign in the set analysis.

IF CONDITION

==>> sum(if(@WS <>'R' and @WS<>'I' ,#QUANTITY/1000))

I need to implement above condition in the set analysis (FROM and TO)

===> IF(@WS<>'R' or @WS<>'I' ,SUM({<%DATE ={">=$(vFrom) <=$(vTo)"} >}#Quantity)/1000)

Need Help...!!!

Gysbert_Wassenaar — Fri, 15 May 2015 11:29:42 GMT

Try: SUM({<@WS-={'I','R'} %DATE ={">=$(vFrom) <=$(vTo)"} >}#Quantity)/1000)

sunny_talwar — Fri, 15 May 2015 11:35:36 GMT

Another option could be:

=Sum({<@WS = e({<@WS = {'I','R'}>}) %DATE = {">=$(vFrom) <=$(vTo)"} >} #Quantity) / 1000)

Best,

Sunny

Fri, 15 May 2015 12:03:34 GMT

IT IS NOT WORKING.....!!!!

sunny_talwar — Fri, 15 May 2015 12:11:09 GMT

Does this work?

SUM({<@WS-={'I','R'}>}#Quantity)/1000)

If it does, then problem would be in this part -> %DATE ={">=$(vFrom) <=$(vTo)"}

Best,

Sunny