Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

soniasweety
Contributor III

Include into set

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)

Tags (3)
3 Replies
eduardo_dimperi
Valued Contributor II

Re: Include into set

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

Re: Include into set

I believe you can code the Set as:

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


-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: Include into set

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 )



Community Browser