Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Restriction on Dimension in List Box

Dear Experts,

I am having a dimension SalesPerson and now I need only those name in my listbox whose product mix(%) is greater than 13 %.

Please find the attachment and suggest.

Regards,

Balraj

1 Solution

Accepted Solutions
tresesco
MVP
MVP

List box expression:

=Aggr(If(sum(Amount)/VAmount*100>13,SalesPerson),SalesPerson)

View solution in original post

3 Replies
tresesco
MVP
MVP

List box expression:

=Aggr(If(sum(Amount)/VAmount*100>13,SalesPerson),SalesPerson)

Anonymous
Not applicable
Author

Hi Balraj,

PFA and check the new list box.

Marc.

its_anandrjs

In a new list box write expression in expression properties.

=Aggr( if( (sum(Amount)/VAmount) > 0.13 ,  sum(Amount)/VAmount ),SalesPerson)

and in Number properties set settings

ListBox.png