topic Re: Count largest in QlikView

Count largest

Thu, 20 Mar 2014 12:55:07 GMT

Hello,

I would like to count how many largest value give 80% from all from subcategory.

Below I have a date sample :

Sum by category

Max 1 form "Other" = 100

Max 2 form "Other" = 60

Other :
Count largest which give over 80% = 2 because ( 160*0,8=128 < 100 and 60 )

Other 1 :

290 *0,8 = 232
Count .. = 3 ( 90 , 70 , 90 ) because 232 =< 250 ( 90+70+90)

If someone could help I would be grateful !!

Nicole-Smith — Thu, 20 Mar 2014 13:39:09 GMT

Fri, 21 Mar 2014 09:06:39 GMT

Yes I seen this post and it is useful but I don't see how can I manage 'largest' issue ?

CELAMBARASAN — Fri, 21 Mar 2014 09:13:36 GMT

Hi,

Check with the dimension limits tab of the chart properties.

Fri, 21 Mar 2014 09:34:52 GMT

Welcome,

Thanks for your post.

I will need do more less something like below :

and dimension limits tab don't work for me.

I will need a set expression

Nicole-Smith — Fri, 21 Mar 2014 13:03:18 GMT

The 80% in the article is the "largest" 80%.