topic Re: Top and Bottom in Bar Chart in QlikView

Top and Bottom in Bar Chart

Fri, 26 Jun 2015 17:00:11 GMT

Hi all,

i calculated stock index rotation with this expression :

=(sum(aggr(SUM({$<DT_DATE={'>$(vMinDate)<=$(vMaxDate)'},DS_TYPE_SHIP={'3'}>} (NR_MOVED_AMOUNT_OUT+NR_CORRECTION)),DT_DATE,DS_COMMENT)) )

(SUM({<DT_DATE={'$(vMaxDate)'},DS_TYPE_SHIP={'3'}>} NR_STOCK_AVAILABLE)/365)

Now i want two bar chart that show me top and bottom 5 Category Product with higher and lower index rotation.

How can i do?

Thank you

Francesca

Re: Top and Bottom in Bar Chart

swuehl — Fri, 26 Jun 2015 17:05:33 GMT

Try creating a bar chart with your dimension you want to show (Category?) and then use dimension limits to limit dimension to largest / smallest 5 values.

Re: Top and Bottom in Bar Chart

sinanozdemir — Fri, 26 Jun 2015 17:06:55 GMT

Hi,

Try to put your function in:

Aggr(Rank(and your sum), NR_STOCK_AVAILABLE) <= 5 --- for top 5

Aggr(Rank(-and your sum), NR_STOCK_AVAILABLE) <= 5 -- for bottom 5

Hope that helps.

Re: Top and Bottom in Bar Chart

Fri, 26 Jun 2015 17:07:55 GMT

I try but doesn't work.