Highest Selling Product

[oseimuduame]

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

[sunny_talwar]

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

[oseimuduame]

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

[sunny_talwar]

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

[oseimuduame]

Multiple Highest Selling Products Like 10

[sunny_talwar]

You can try this:

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

[oseimuduame]

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.

[sunny_talwar]

Across all stores or just that particular store?

[oseimuduame]

Accross All Stores

[sunny_talwar]

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