Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Need to list top and bottom X products based on sales value???

Hi, Please help me to list say top and bottom 8 products based on sales for particular year?   i should able to get by just entering X=? some no. to get the result.... please see the attachment for model template given to me

1 Solution

Accepted Solutions
Not applicable

Re: Need to list top and bottom X products based on sales value???

See the attached file.

7 Replies
Not applicable

Re: Need to list top and bottom X products based on sales value???

See the attached file.

Not applicable

Need to list top and bottom X products based on sales value???

Hi Erika jain... i couldn't see any attachment... please can u post it again

Need to list top and bottom X products based on sales value???

Hi,

   All you have to do is Create a chart with Customer name. Add expression as Sum(Sales).

   Go to Sort. Keep Sum(Sales) with ascending in case you want bottom customer and Descending in cae you want Top Customer.

   You can limit the number from Properties-> Presentation -> Max Number(1 -100) ->Set this to 8.

   Hope this will help you

Regards,

Kaushik Solanki

Need to list top and bottom X products based on sales value???

Hi,

Very Nice Example to help for that Top Values. It help very much.

Anand

Regards

Not applicable

Need to list top and bottom X products based on sales value???

hi, could you post the codes here?

i'm unable to open other users' files

Not applicable

Re: Need to list top and bottom X products based on sales value???

Good morning! friend

I am facing  the same problem and I need your help

I try to display the first 10 sales per country in a Pivot table

sales.PNG.png

so I added this expression in dimensions

Capture.PNG.png

and as a result I have

Capture.PNG.png

as you can see  for 2010 it gives a result  USA-> France-> germany  and the logical order is USA-> France-> UK

  why?

Thank you for your answers

Not applicable

Re: Need to list top and bottom X products based on sales value???

This is great but what is I want product to be selected on insertion of vTop variable.

Currently chart is changing on variable but there is no selection of subproducts.

I want product to be selected as well

Regards,

Gaurav