topic Re: Limit Dimension in QlikView

Limit Dimension

karin_nevo — Sun, 03 Nov 2019 19:22:33 GMT

Hi,

I have a scatter chart with 3 expressions.

I want to limit the chart to show only the top 100 values of the first expression.

I am using DImension Limits tab the restrict only largest 100 values, but it is showing the largest 100 based on the third expression and not the first.

If I only use 2 expressions it works.

Any help is appriciated.

Thanks,

Karin

Re: Limit Dimension

Arthur_Fong — Mon, 04 Nov 2019 01:02:15 GMT

Remove the dimension limits and try this in calculated dimension:

=if(aggr(rank(aggr(<Exp 1>,[Dimension in Chart])),[Dimension in Chart])<100,[Dimension in Chart],null())

Under settings on selected dimension,

Check(Tick) suppress when value is null.

Re: Limit Dimension

Brett_Bleess — Thu, 07 Nov 2019 22:02:19 GMT

Karin, did Arthur's suggestion work for you? If so, please be sure to come back to the thread and use the Accept as Solution button on his post to give him credit and let others know his solution did work. If you are still working on things, leave an update.

Regards,
Brett

Re: Limit Dimension

karin_nevo — Fri, 08 Nov 2019 19:08:50 GMT

Thanks Arthur, it works!