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

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

Fri, 27 May 2011 09:40:45 GMT

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

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

Fri, 27 May 2011 09:45:11 GMT

See the attached file.

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

Fri, 27 May 2011 09:46:40 GMT

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???

kaushiknsolanki — Fri, 27 May 2011 09:49:52 GMT

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???

its_anandrjs — Sun, 29 May 2011 13:03:14 GMT

Hi,

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

Anand

Regards

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

Mon, 04 Jul 2011 04:28:31 GMT

hi, could you post the codes here?

i'm unable to open other users' files

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

Fri, 30 May 2014 07:03:24 GMT

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

so I added this expression in dimensions

and as a result I have

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

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

Fri, 07 Nov 2014 14:35:11 GMT

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