Multi select on a filter using triggers

polisetti — Thu, 15 May 2014 10:29:08 GMT

Hi,

I have a product selection on my report, in which user should be able to select multiple products for all conditions except 1 condition.

I have written the below expression:

=if(GetFieldSelections([_Select Chart NM])='Top 15 & Bottom 15 Physicians',

IF(GetSelectedCount([Brand Name])=0,SubField( Concat(DISTINCT [Brand Name], ','),',')

,subfield(GetFieldSelections([Brand Name]),',')) ,

'("'&GetFieldSelections([Brand Name],'"|"')&'")')

What this expression does is, when top 15 & bottom 15 physicians are selected, then the user cannot select more than 1 product. whereas on all other selections user should be able to select multiple products and '("'&GetFieldSelections([Brand Name],'"|"')&'")'

expression comes into picture.

This expression works fine, but the problem is when the brand name has spaces in between it acts wierd. Say a user selects brand: "ABC XY" and brand "EFG", then at the first instant user can see the data for both of the selected products, but when the user selects anything else, say changes time period on report etc the brand selection with space, i.e "ABC XY" goes off and user can see data only for brand "EFG".

Re: Multi select on a filter using triggers

Thu, 15 May 2014 13:39:25 GMT

Polisetti,

may you attach sample application to illustrate your problem?

regards

Darek

topic Re: Multi select on a filter using triggers in QlikView

Multi select on a filter using triggers

Re: Multi select on a filter using triggers