topic Re: Dynamic Dimension Limits do not work in QlikView

Dynamic Dimension Limits do not work

hugmarcel — Wed, 16 Apr 2014 18:08:46 GMT

I have a table diagram with products and sales. Of all the rows in the table, I'd like to

- show only first 20% of all SubProduct1s

- show only first 40% of all SubProduct2s

- show only first 60% of all SubProduct3s

Thus limiting the number of rows in the table.

I tried with something like

PICK

(Match(PRODUCT,'PRODUCT1','PRODUCT2','PRODUCT3'),AGGR(NODISTINCT COUNT(SUBPRODUCT),PRODUCT) * (vProzProd1 / 100)

but I nver get the desired result.

See example attached. How can I do this with the help of variables.?

Thx - Marcel

Re: Dynamic Dimension Limits do not work

Wed, 16 Apr 2014 21:02:42 GMT

Marcel,

i think with dim limits as with set analysis it might be difficult.

But there is some solution of course.

I hope that it helps.

regards

Darek

Re: Dynamic Dimension Limits do not work

hugmarcel — Thu, 17 Apr 2014 06:59:36 GMT

thank you for this rank-approach. I know its possible using rank or similar, however, I wished to get the same using dynamic dimension limitation, as it seemed easier at first look.

Now, I'm having the impression that the dimension limits do not support dynamic expressions, such as

PICK(Match(PRODUCT,'PRODUCT1','PRODUCT2','PRODUCT3'),AGGR(NODISTINCT COUNT(SUBPRODUCT),PRODUCT) * (vProzProd1 / 100)

and similar. Even the simple PICK(Match(PRODUCT,'PRODUCT1','PRODUCT2','PRODUCT3'),1,2,3) does not work as dimension limit.

Regards - Marcel

Re: Dynamic Dimension Limits do not work

Thu, 17 Apr 2014 07:02:09 GMT

Anyway i'am gald if my answer is helpful

regards

Darek