Include into set

[soniasweety]

Hi all,

Anand Chouhan

I have a expression in dimension am using  like below 

=if(Task_Days>=limit, ID)    

so I just want to include the some other condition  how can I do this?  can anyone give idea?

there is a field  assigned   in that I have 10 values  like  a,b,c,d,e.......  so on  but I want to  display only    a,b,c  only

=if(Task_Days>=limit, ID) 

how can I incorporate with above expression? 

tried below not working

=aggr(only({<Assigned={'a','b','c'}>}ID) if(Task_Days>=limit, ID),ID)

[eduardo_dimperio]

IF(Task_Days>=limit AND (Assigned='a' OR Assigned='b' OR Assigned='c' , ID)

[rwunderlich]

I believe you can code the Set as:

{<Assigned={'a','b','c'}, ID={"=Task_Days>=limit"}>}

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[its_anandrjs]

I believe it would be

By If condition try

=Sum( if([Job code] >= [Job code] and Match([Job code],'a','b','c' ) ,[Job code]  ))

By SET Analysis try

=Sum( {<Assigned={'a','b','c'} ,  Task_Days = {">=$(=limit)"}  >}  ID )