topic Re: help in QlikView

help

Sat, 07 Feb 2015 17:52:26 GMT

Hi,

Am new to qlikview and i need a clarification.

There are I have 9 records as i shown in PFB.But here conditionally I want to display only top 3 records in the chart.

how could i accomplish this by the expression?

Pls help me out in this.

R'ds

QVuser

Re: help

Anonymous — Sat, 07 Feb 2015 17:57:18 GMT

Have look at the Dimension Limits tab of your Bar Chart's Properties..

Re: help

terezagr — Sat, 07 Feb 2015 17:59:55 GMT

In Dimensions Limits tab Limits which values are displayed using the first expression->show only Largest 4 values

Re: help

terezagr — Sat, 07 Feb 2015 18:01:17 GMT

Sorry, should be Largest 3 and in Options untick Show Others...

Re: help

Peter_Cammaert — Sat, 07 Feb 2015 18:01:42 GMT

In your chart, go to Properties->Dimension Limits. Enable "Restrict which values are displayed using the first expression", select Show only, and from the listbox immediately below, choose "Largest". Then enter a suitable number in the "Values" input field. 3 in your case but you may want to increase that number as the bar chart will be rather empty with only 3 bars.

Do not forget to disable "Show Others" at the bottom. It serves no purpose to amways have an "Others" bar as the largest one.

Re: help

Sat, 07 Feb 2015 18:09:37 GMT

It's not only for bar chart(I just took an example with bar) irrespective of by choosing any kind of chart. suppose If i don't have dim limits tab then how could i achieve this by the expression conditionally is it possible????

am totally strucked here pls help me out in this

Re: help

Anonymous — Sat, 07 Feb 2015 18:15:10 GMT

Yup, there are other ways. But I would suggest you do it the easy way with the QlikView built in Dimension Limits.

Re: help

Peter_Cammaert — Sat, 07 Feb 2015 18:27:24 GMT

Which chart doesn't have Dimension Limits? Pivot table is a special case anyway.

As Bill says, it's easiest when you use the Dimension Limits tab. If you want to be creative, have a look at how to use Rank(Aggr()) to obtain the same result in http://community.qlik.com/docs/DOC-7717

Re: help

maxgro — Sat, 07 Feb 2015 18:51:07 GMT

here a good doc for different way to show top

Show Top Performers

Re: help

ashfaq_haseeb — Sun, 08 Feb 2015 06:45:54 GMT

Hi,

Check if this helps

Regards

ASHFAQ