Set analysis Problem of Using (Not IN) Or EXCLUSION URGENT

Wed, 08 Sep 2010 13:18:17 GMT

Hi All
I am facing one problem in set analysis in using (NOT IN) Clause .
I am having cases where i am having file Nos (DebtNo.) those are present in Current month(Suppose-Aug)
and Having File No those are present in Previous month that will be July .
Now i want one result using set anlysis in which i can get cases those were present in July BUT NOT IN August ..
....

or i can take another case like i want cases from august(Current Month) those were absent (Not in) in July .

How can i get this result using set anlysis because i am using current and previous month logic here .
Please find out attached doccuement for your refrence and suggest if you can do the needfull changes in that doccument.

As per my uderstanding we should use (NOT IN) Syntax but i dont know how to use or implement this is set analysis...
Please help me ..........

Please reply me @ dushyant@iconresources.com

Set analysis Problem of Using (Not IN) Or EXCLUSION URGENT

qliksus — Thu, 09 Sep 2010 06:54:12 GMT

use the following expression and try it out

sum

(aggr( if(count({$<YM={'$(vLast1YearMonth)'},Year=,Quarter=,MonthName=,BUCKER={1} >} DebtNo) = '0' and

count

({$<YM={'$(vCurrentyearmonth)'},Year=,Quarter=,MonthName=,BUCKER={'1'}>} DebtNo)='1',

count

({$<YM={'$(vCurrentyearmonth)'},Year=,Quarter=,MonthName=,BUCKER={'1'}>} DebtNo)),BRANCH,DebtNo))

Tell me if this is not working

topic Set analysis Problem of Using (Not IN) Or EXCLUSION URGENT in QlikView

Set analysis Problem of Using (Not IN) Or EXCLUSION URGENT

Set analysis Problem of Using (Not IN) Or EXCLUSION URGENT