topic Re: GAUGE CHART ISSUE in QlikView

GAUGE CHART ISSUE

marikabi — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: GAUGE CHART ISSUE

sunny_talwar — Tue, 29 Nov 2016 16:54:43 GMT

Remove ALL and see if that works

SUM(SALES)/SUM(TOTAL ALL SALES)

Re: GAUGE CHART ISSUE

marikabi — Wed, 30 Nov 2016 07:49:33 GMT

Hi,

thank you for your answer..

unfortunately it doesn't work.

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

Re: GAUGE CHART ISSUE

pathiqvd — Wed, 30 Nov 2016 07:58:07 GMT

Try this

SUM(SALES)/SUM(ALL SALES)

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

Re: GAUGE CHART ISSUE

sunny_talwar — Wed, 30 Nov 2016 08:28:05 GMT

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)

Re: GAUGE CHART ISSUE

marikabi — Fri, 02 Dec 2016 09:01:56 GMT

THANK YOU SO MUCH!!

Re: GAUGE CHART ISSUE

sunny_talwar — Fri, 02 Dec 2016 10:59:43 GMT

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