Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
oseimuduame
Contributor II

Highest Selling Product

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

14 Replies

Re: Highest Selling Product

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

oseimuduame
Contributor II

Re: Highest Selling Product

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

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

oseimuduame
Contributor II

Re: Highest Selling Product

Multiple Highest Selling Products Like 10

Re: Highest Selling Product

You can try this:

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

oseimuduame
Contributor II

Re: Highest Selling Product

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

Across all stores or just that particular store?

oseimuduame
Contributor II

Re: Highest Selling Product

Accross All Stores

Re: Highest Selling Product

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