Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
soniasweety
Valued Contributor 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)

Tags (2)
1 Solution

Accepted Solutions
MVP
MVP

Re: Include into set

Try like:

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

4 Replies
MVP
MVP

Re: Include into set

Try like:

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

Re: Include into set

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 )

Re: Include into set

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)

soniasweety
Valued Contributor III

Re: Include into set

thanks all its working fine