topic Re: Select in Field Using Expression in Text Object in QlikView

Select in Field Using Expression in Text Object

Anonymous — Tue, 09 Dec 2014 23:39:55 GMT

Trying to set an action on a text object in Select in Field for the field Client and Search String:

=if(aggr(sum({1<Week={'>=2'}, Flag={0}>} Sales) < 1000 and sum({$<Flag={0}>} SalesWTD) >= 1000, Client), Client)

Goal is to select all those Client values that fulfill above expression.

Thanks.

Wed, 10 Dec 2014 00:04:48 GMT

your 2 conditions should be separated by '+' symbol not the 'and' keyword so that it becomes a proper set analysis expression.

jagan — Wed, 10 Dec 2014 03:17:35 GMT

Hi,

Try this expression

='(' & Concat(aggr(if(sum({1<Week={'>=2'}, Flag={0}>} Sales) < 1000 AND sum({$<Flag={0}>} SalesWTD) >= 1000, Client), Client), ',') & ')'

Regards,

Jagan

Anonymous — Wed, 10 Dec 2014 16:28:40 GMT

Ramkumar, I tried this but didn't work:

='('&Concat(Aggr(if(sum({1<Week={'>=2'}, Flag={0}>} Sales) < 1000 + sum({$<Flag={0}>} SalesWTD) >= 1000, Client), Client),',')&')'

Anonymous — Wed, 10 Dec 2014 16:29:31 GMT

Jagan Mohan,

Tried your approach but didn't work:

='('&Concat(Aggr(if(sum({1<Week={'>=2'}, Flag={0}>} Sales) < 1000 + sum({$<Flag={0}>} SalesWTD) >= 1000, Client), Client),',')&')'

jagan — Thu, 11 Dec 2014 01:59:18 GMT

Hi,

Dont use + sign the expression I given is not having +,

This will give comma separated values of Client satisfying the condition

=Concat(aggr(if(sum({1<Week={'>=2'}, Flag={0}>} Sales) < 1000 AND sum({$<Flag={0}>} SalesWTD) >= 1000, Client), Client), ',')

If you want to use this in Select In Field trigger then you have to use | as separator and ( ).

='(' & Concat(aggr(if(sum({1<Week={'>=2'}, Flag={0}>} Sales) < 1000 AND sum({$<Flag={0}>} SalesWTD) >= 1000, Client), Client), '|') & ')'

This is working for me, if not working for you then attach a sample file.

Regards,

Jagan.