Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
deepti_singh
Creator II
Creator II

How to limit the dropdown?

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

2 Replies
ramoncova06
Partner - Specialist III
Partner - Specialist III

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

deepti_singh
Creator II
Creator II
Author

Ramon,

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