topic Re: Conditional Top 10 values in QlikView

Conditional Top 10 values

Fri, 29 Jan 2016 09:36:31 GMT

Hello friends,

Please refer to image1 shown above

I need to show top 10 values shown in image2 .Grey color highlighted cells should always be included in top 10.

It would be great if you have some solution for this..

Thanks in advance !!!

Re: Conditional Top 10 values

Anonymous — Fri, 29 Jan 2016 12:08:41 GMT

What logic highlights them in grey ?

Re: Conditional Top 10 values

Fri, 29 Jan 2016 12:14:14 GMT

all 3 highlighted lies in a same brand for ex:-

A11	A
	B
	C

Re: Conditional Top 10 values

mohsinqlik — Sat, 30 Jan 2016 07:11:57 GMT

Dear Snehal,

You can create static variables to find top 7 ranked Make and another 3 variable to find 10,12 and 14th ranked Make and pass them in you those variable in your set analysis expression of volume. This will restrict your dimension to those 10 values. Hope this helps.

Regards,

Mohsin Choudhary

Re: Conditional Top 10 values

Anonymous — Sat, 30 Jan 2016 17:48:45 GMT

Hi,

an example attached.

Can this solution help you?

Re: Conditional Top 10 values

HirisH_V7 — Sat, 30 Jan 2016 18:26:16 GMT

Hi ,

Check this,

=If(MAKE= 'ANT' ,Sum(VOLUME),
If(MAKE= 'BRU' ,Sum(VOLUME),
If(MAKE= 'ROBY' ,Sum(VOLUME),
aggr(if(Rank(Sum(VOLUME))<=10,VOLUME),MAKE))))

In place of the Fields you can place your required fields.

Hope this helps,

PFA,

Hirish

Re: Conditional Top 10 values

Mon, 01 Feb 2016 06:14:01 GMT

Thanks Hirish.. This solution is helpful