topic Re: Highest Selling Product in QlikView

Highest Selling Product

oseimuduame — Wed, 25 Nov 2020 16:16:04 GMT

Good Morning,

I have a little thing to ask this morning.

i have my Sales Report on Qlikview and i have 8 Branches and i want to get the HIGHEST SELLING PRODUCTS for a Day Across All my Branches.

Please any help will be appreciated.

Thank You

Re: Highest Selling Product

sunny_talwar — Thu, 05 Jan 2017 10:54:14 GMT

What is your logic behind 'HIGHEST SELLING PRODUCTS'? Does it mean one highest selling product from each branch?

Re: Highest Selling Product

oseimuduame — Thu, 05 Jan 2017 11:19:41 GMT

I mean the HIGHEST SELLING PRODUCT ACROSS ALL BRANCHES.

For Example; if i am selling Iphone 7 and other Iphone, i want to know which of the Iphone Sells most across all branches.

Thank You

Re: Highest Selling Product

sunny_talwar — Thu, 05 Jan 2017 11:52:47 GMT

Just one single product or multiple highest selling products? And if it is multiple, then how many?

Re: Highest Selling Product

oseimuduame — Thu, 05 Jan 2017 12:51:24 GMT

Multiple Highest Selling Products Like 10

Re: Highest Selling Product

sunny_talwar — Thu, 05 Jan 2017 12:56:23 GMT

You can try this:

Sum({<Product = {"=Rank(Sum(Sales)) <= 11"}>}Sales)

Re: Highest Selling Product

oseimuduame — Thu, 05 Jan 2017 13:22:14 GMT

Thank You.

But Its not giving me what i want.

Let me explain again. i have a store and i want to know which of my products sells Fast.

Re: Highest Selling Product

sunny_talwar — Thu, 05 Jan 2017 13:25:19 GMT

Across all stores or just that particular store?

Re: Highest Selling Product

oseimuduame — Thu, 05 Jan 2017 13:35:38 GMT

Accross All Stores

Re: Highest Selling Product

sunny_talwar — Thu, 05 Jan 2017 13:37:16 GMT

So I think it should be working, can you share an example (sample) where it isn't working?

Re: Highest Selling Product

oseimuduame — Thu, 05 Jan 2017 13:44:42 GMT

i want it to show only those Items. i.e the Highest Selling Items

Below is my Script:

Sum({<ITEM_DESCRIPTION1= {"=Rank(Sum(INVC_EXT_PRICE)) <= 11"}>}INVC_EXT_PRICE)

Re: Highest Selling Product

sunny_talwar — Thu, 05 Jan 2017 13:48:20 GMT

Is it showing more than 10 items? Is that what the issue is?

Re: Highest Selling Product

oseimuduame — Thu, 05 Jan 2017 14:30:23 GMT

Yes its showing more than 10 items. i need it too show just the 10 Items

Re: Highest Selling Product

sunny_talwar — Thu, 05 Jan 2017 14:33:44 GMT

That is interesting, do you have a sample you can share? or few rows of raw data?

Preparing examples for Upload - Reduction and Data Scrambling

Uploading a Sample

Re: Highest Selling Product

Anonymous — Mon, 09 Jan 2017 10:06:28 GMT

Hi Omotayo,

try this:

Sum(Aggr(Sum({<ITEM_DESCRIPTION1= {"=Rank(Sum(INVC_EXT_PRICE)) < 11"}>}INVC_EXT_PRICE),Store))

Regards!