topic Re: top products ? in QlikView

top products ?

Wed, 12 Nov 2014 14:13:39 GMT

HI All,

I need to show top 10 products based on Sales Amount..

I need to Show % of Sales Amount as well as Gross Margin %.. ?

and also Units in lakhs I want to show the Sales Amount is this possible,..

Can any one share Some example related to this with this bar chart..

Regards,

Heather

Re: top products ?

MK_QSL — Wed, 12 Nov 2014 14:17:31 GMT

Create a Straight Table

Dimension

Calculated Dimension

IF(Aggr(Rank(SUM(Sales),4),Product)<=10,Product)

Tick Suppress When Value is NULL

Expression

1) SUM(Sales)

2) SUM(Sales) / SUM(Total Sales)

3) SUM(Sales)

TICK RELATIVE CHECKBOX

4) NUM((SUM(Sales)-SUM(Purchase))/SUM(Sales),'#,0.00%')

5) COUNT(Units)

Re: top products ?

agomes1971 — Wed, 12 Nov 2014 14:58:27 GMT

Hi,

this is the solution for the ten best and what about the ten worst?

Regards

André Gomes

Re: top products ?

Wed, 12 Nov 2014 16:10:06 GMT

I need to show Sales amount in Lakhs..

and also I have to create Bar chart & Pie charts..

Can you share with some example, So that it will be clear to me..

Regards,

Kacy

Re: top products ?

MK_QSL — Wed, 12 Nov 2014 16:13:51 GMT

IF(Aggr(Rank(-SUM(Sales),4),Product)<=10,Product)

Re: Re: top products ?

ashfaq_haseeb — Wed, 12 Nov 2014 16:30:03 GMT

HI,

Check this.

Re: Bottom 5 values

Regards

ASHFAQ

Re: top products ?

agomes1971 — Wed, 12 Nov 2014 16:38:40 GMT

Hi,

please see the attached...

Hope it helps

André Gomes

Re: top products ?

its_anandrjs — Wed, 12 Nov 2014 17:00:04 GMT

Hi,

For Top 10 results

Dimension:-

=if(aggr(rank(sum(Value)),Dimension)<=10,Dimension) //And tick on suppress when value is null

Expression:-

Sum(Value)

For Top worst

=if(aggr(rank( - sum(Value)),Dimension)<=10,Dimension) //And tick on suppress when value is null

Expression:-

Sum(Value)

Note:- By using same dimension and expression you can change the chart type and use the Pie and Bar charts and also straight chart.

Regards

Anand