Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist III
Specialist III

Include into set

Hi all,

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)

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Try like:

=if(Match(Assigned, 'a','b','c') and Task_Days>=limit, ID)

View solution in original post

4 Replies
Highlighted
MVP
MVP

Try like:

=if(Match(Assigned, 'a','b','c') and Task_Days>=limit, ID)

View solution in original post

Highlighted

Rather then using this expression why not you using this expression on the Expression not on dimension.

Ex:-

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

Highlighted

May be create a flag in the script

If(Task_Days >= limit, 1, 0) as Flag and then use like this

=Aggr(Only({<Assigned={'a','b','c'}, Flag = {1}>} ID),ID)

or

=If(Flag = 1 and Match(Assigned, 'a', 'b', 'c'), ID)

Highlighted
Specialist III
Specialist III

thanks all its working fine