Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
wenkew186
Contributor

Dynamic Dimension but in limit number

Hi all,

I have a pivot table. one of dimension have 5 values, and the dimension also is list box filter.

so now , I need limit this dimension show less 3 values, base on select in list box.

if no select then 3 values showing. if more than 3 values be selected then 3 showing.

how to do it?

thanks all!

1 Reply
Partner
Partner

Re: Dynamic Dimension but in limit number

hello, use if clause with getselectedcount (FieldName [, IncludeExcluded]) function and rank()