Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

See the attached file.

View solution in original post

7 Replies
Not applicable
Author

See the attached file.

Not applicable
Author

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

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
its_anandrjs

Hi,

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

Anand

Regards

Not applicable
Author

hi, could you post the codes here?

i'm unable to open other users' files

Not applicable
Author

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
Author

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