Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

singhpooja
Contributor III

Sales from top 10 location Vs Total Sales in Gauge chart

Hi Experts,

Can you help me to get solution of implementing sales from top 10 locations vs total sales in gauge chart

Thanks ,

Pooja

4 Replies
YoussefBelloum
Esteemed Contributor

Re: Sales from top 10 location Vs Total Sales in Gauge chart

Hi,

Can you attach sample data ? or a QVF ?

OmarBenSalem
Esteemed Contributor

Re: Sales from top 10 location Vs Total Sales in Gauge chart

sum({<location={"=rank(sum(sales),location)<=10"}>}sales) / sum(total sales)


or


sum({<location={"=rank(sum({1}sales),location)<=10"}>}sales) / sum(total sales)


(depends on how u define top 10 locations)


ps: u can alter this :

sum(total sales)


as

sum(total {<location>} sales)

or

sum(all sales)

It all depends on what u're willing to analyze

Per analogy; here's top 3 vs Total : (a,c and d)

Capture.PNG

singhpooja
Contributor III

Re: Sales from top 10 location Vs Total Sales in Gauge chart

Thanks for your help bud has not worked as I wanted.

Thanks,

Pooja

OmarBenSalem
Esteemed Contributor

Re: Sales from top 10 location Vs Total Sales in Gauge chart

It all depend on what u have.

Can u share a screenshot of what u had using this? and what u're expecting maybe?

Community Browser