Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

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

Re: Dynamic Dimension but in limit number

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