GAUGE CHART ISSUE

[marikabi]

Hello Guys,

I am trying to create a gauge chart in order to calculate the percentage of the sales in a specific shop, on the total sales.

For the time being I am using this formula:

SUM(SALES)/SUM(TOTAL ALL SALES)

It works, but I would like that when filtering a specific month/week, also the total value changes.

I mean, for example without filtering a specific shop, I want to obtain 100% (when not filtering anything) and 100% when filtering only one week/month,

Could you please help me?

Many thanks in advance,

Cheers,

Marika

[sunny_talwar]

Remove ALL and see if that works

SUM(SALES)/SUM(TOTAL ALL SALES)

[marikabi]

Hi,

thank you for your answer..

unfortunately it doesn't work.

Using this formula, it filters also the shops...

[pathiqvd]

Hi

Try this

SUM(SALES)/SUM(ALL SALES)

or

SUM(SALES)/SUM({1} SALES)

[sunny_talwar · Accepted solution]

Do you want this expression to not change based on selection in shop? or do you not want the denominator to not change based on selection in shops?

If the whole expressions should not change based on selection in shops:

Sum({<Shops>}SALES)/Sum({<Shops>} TOTAL SALES)

Only denominator should not change based on selection in shops

Sum(SALES)/Sum({<Shops>} TOTAL SALES)

[marikabi]

THANK YOU SO MUCH!!

[sunny_talwar]

Awesome!! I am glad we final resolved it. I would suggest you to close this thread by marking correct response now.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny