topic Re: Top 300 Items in QlikView

Top 300 Items

Fri, 12 Oct 2012 09:28:35 GMT

How do i do a formula for top 300 items by quantity.

regards

Nayan

Re: Top 300 Items

Siva_Sankar — Fri, 12 Oct 2012 09:43:09 GMT

Hi, You can try expression like =Only({} quantity) In case of Qlikview 9 use expression as Only(quantity)) and Then go to the properties-->Presentation-->under dimension limitations check the option max visible number and set as 300, This requires to be sort by y value descending. For 10 and 11 versions... use dimension limits Regards. Siva Sankar k

Re: Top 300 Items

Fri, 12 Oct 2012 09:43:23 GMT

Hai ,

Please find the attachment using range function you can restrict the numbers.

Thanks

Rathish

Re: Top 300 Items

thomas_skariah — Fri, 12 Oct 2012 10:14:41 GMT

Hi Nayan,

Not sure which chart you are using, if you are usiing Striaght chart or bar chart then you can go with suggestions given by siva,but if you are using pivot chart then refer the following link.

http://community.qlik.com/message/266359#266359

Regards,

Tom

Re: Top 300 Items

Fri, 12 Oct 2012 10:22:04 GMT

Hi Siva

I'm on Qlikview 10. In the presentation tab it only has the option from 1 to 100. How do I show it up to 300.

kind regards

Nayan

Re: Top 300 Items

Fri, 12 Oct 2012 10:24:14 GMT

Hi Tom

It's a straight chart. Under presentation tab , it only shows from 0 - 100. How do i show the top 300 items.

Thanks

regards

Nayam

Re: Top 300 Items

thomas_skariah — Fri, 12 Oct 2012 10:45:38 GMT

Hi Nayan,

You can refer from the below link

http://community.qlik.com/message/256499#256499

Regards,

Tom