Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

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)

3 Replies
eduardo_dimperio
Specialist II
Specialist II

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

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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 )