Discussion Board for collaboration related to QlikView App Development.
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.
List box expression:
View solution in original post
PFA and check the new list box.
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