Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
polisetti
Creator II
Creator II

Multi select on a filter using triggers

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".

1 Reply
Not applicable

Polisetti,

may you attach sample application to illustrate your problem?

regards

Darek