Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
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

Highlighted

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?