topic Re: How to limit the dropdown? in QlikView

How to limit the dropdown?

deepti_singh — Wed, 22 Apr 2015 17:01:15 GMT

Hi,

I have a straight table in which I have applied some limitations in 3 of the 10 columns. But when I insert the dropdown option for the three columns, the data in the drop down is not limited. Any idea how can I limit that as well, without limiting in the backend?

Thanks.

Regards,

Deepti

Re: How to limit the dropdown?

ramoncova06 — Wed, 22 Apr 2015 17:07:28 GMT

would need to see you file, but you can try with

by apply an aggr to your expression

=Aggr(If(Sum(Sales)>=Max(TOTAL Aggr(Sum(Sales), Customer), 4), Customer), Customer)

Customers Having Top 4 Values

Re: How to limit the dropdown?

deepti_singh — Wed, 22 Apr 2015 17:12:39 GMT

Ramon,

I answered my own question. I made the mistake of limiting an expression and not the individual columns.
Thanks anyways!