topic Re: Dimension Limit don't work (example attached ) in QlikView

Dimension Limit don't work (example attached )

dferreirogft — Thu, 27 Jul 2017 11:58:07 GMT

Good Afternoon,

I'm trying to get the dimension limits to work on a very simple straight table but I cannot understand what this option is doing.

I want Qlikview to return me thoose rows that aggregated sums up to the 80% of the total of the rows.

I have different results using qlikview capability or an embeded formula to manual calculate the limit.

Could someone help me?

Re: Dimension Limit don't work (example attached )

ali_hijazi — Thu, 27 Jul 2017 12:11:24 GMT

this shows the top 3

sum({<pais={"=aggr(rank(sum(nro)),pais)<4"}>} nro)

you can put a variable instead of hard-coded ranks e.g. 4

Re: Dimension Limit don't work (example attached )

Nagaraju_KCS — Thu, 27 Jul 2017 12:13:40 GMT

go to Dimension Limits --> uncheck Show Others property

hope it helps

Re: Dimension Limit don't work (example attached )

dferreirogft — Thu, 27 Jul 2017 12:16:10 GMT

Hi,

This is not what I aim for. This will show me the top 3, but not those rows that sum up the 80% of the total

Re: Dimension Limit don't work (example attached )

dferreirogft — Thu, 27 Jul 2017 12:17:08 GMT

Already tried and, not working:

Re: Dimension Limit don't work (example attached )

sunny_talwar — Thu, 27 Jul 2017 12:18:03 GMT

It's weird, I have used it in the past without issues... but even your expression one isn't correct... you need to sort by an expression to get the right result

Re: Dimension Limit don't work (example attached )

dferreirogft — Thu, 27 Jul 2017 12:20:13 GMT

You're right. With the expression it works, but i need to know why it is not working with the usual flow.

It will be applied to a table with 20 expresions. So using expression like limit won't be a solution for me...

Re: Dimension Limit don't work (example attached )

Nagaraju_KCS — Thu, 27 Jul 2017 12:20:14 GMT

go to Dimension Limits --> uncheck Show Others property

See attached..

Re: Dimension Limit don't work (example attached )

dferreirogft — Thu, 27 Jul 2017 12:22:25 GMT

oh! it's magic... what did you do to solve it?

Re: Dimension Limit don't work (example attached )

sunny_talwar — Thu, 27 Jul 2017 12:24:00 GMT

I am curious too

Re: Dimension Limit don't work (example attached )

sunny_talwar — Thu, 27 Jul 2017 12:25:11 GMT

Not sure why using an expression based solution a not good option for a table with 20 expressions? Although it does compromise some efficiency, but you get much better control over the expression compared to the inbuilt capability .

Re: Dimension Limit don't work (example attached )

dferreirogft — Thu, 27 Jul 2017 12:27:15 GMT

Compromise a little bit the performance in a really huge dashboard it's not just a bit...trust me.

Re: Dimension Limit don't work (example attached )

Nagaraju_KCS — Thu, 27 Jul 2017 12:31:53 GMT

nothing i did, just I unchecked the property.

Re: Dimension Limit don't work (example attached )

sunny_talwar — Thu, 27 Jul 2017 12:33:05 GMT

I agree ... I hope qv_testing‌'s technique work for you....

Re: Dimension Limit don't work (example attached )

dferreirogft — Thu, 27 Jul 2017 12:34:33 GMT

Wich property?

Re: Dimension Limit don't work (example attached )

sunny_talwar — Thu, 27 Jul 2017 12:41:35 GMT

Look at this

it seems that Dimension Limits are not going to give you any performance benefit here

QlikView Blog Q-Tip #5 – Show Top Performers. Common but not too trivial. | Natural Synergies‌

May be troyansky‌ can share his insights on this topic....

Re: Dimension Limit don't work (example attached )

dferreirogft — Thu, 27 Jul 2017 12:48:48 GMT

Raju‌

Really, really wierd. Just opened your document. Copied the table, unchecked the limit option and checked it again.

Then it's not working anymore.

Maybe it's a bug of my qlikview version?

I'm using 12.10.20500.0 SR7

Any light here?

Re: Dimension Limit don't work (example attached )

sunny_talwar — Thu, 27 Jul 2017 12:53:23 GMT

I am using SR6.... I had the same issue

Re: Dimension Limit don't work (example attached )

dferreirogft — Thu, 27 Jul 2017 13:12:43 GMT

Just checked with QV 11 and it's working... QV 12 Bug detected

Re: Dimension Limit don't work (example attached )

Nagaraju_KCS — Thu, 27 Jul 2017 13:20:05 GMT

Seriously, Qlikview 12 many bugs.

recently i had faced one issue.

My container Objects had gone empty....