Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
balrajahlawat
Champion
Champion

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)

View solution in original post

marcarreras
Specialist
Specialist

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