topic Re: Include into set in QlikView

Include into set

soniasweety — Wed, 25 Nov 2020 16:16:04 GMT

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)

tresB — Tue, 29 Aug 2017 10:40:06 GMT

Try like:

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

its_anandrjs — Tue, 29 Aug 2017 10:47:02 GMT

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 )

sunny_talwar — Tue, 29 Aug 2017 11:24:41 GMT

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)

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

soniasweety — Tue, 29 Aug 2017 13:08:08 GMT

thanks all its working fine