topic Re: Restriction on Dimension in List Box in QlikView

Restriction on Dimension in List Box

Anonymous — Fri, 17 Oct 2014 05:57:44 GMT

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

tresB — Fri, 17 Oct 2014 06:05:22 GMT

List box expression:

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

Anonymous — Fri, 17 Oct 2014 06:05:44 GMT

Hi Balraj,

PFA and check the new list box.

Marc.

its_anandrjs — Fri, 17 Oct 2014 06:18:32 GMT

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