topic Re: Gauge chart in QlikView

Gauge chart

Tue, 24 Mar 2015 15:13:44 GMT

I like to modify the gauge chart in the example i attached.

I try to introduce some data limitation, but they not work.

please could you help me. thanks

Re: Gauge chart

MK_QSL — Tue, 24 Mar 2015 15:26:22 GMT

You need to use expression as below

=NUM(SUM({<Year = {'$(=Year(Today()))'}, AlsisStatus = {'G','J'}>}OrderCount)/2000,'#0.00%')

Re: Gauge chart

Tue, 24 Mar 2015 15:37:04 GMT

Qlickview said ....Error: Garbage after Expression:"NUM".

But expression was defined ok from Experssion editor

Re: Gauge chart

Tue, 24 Mar 2015 17:01:44 GMT

Hi i have 0 as value now as you can see from attached picture, please where is the errors?

Re: Gauge chart

Anonymous — Tue, 24 Mar 2015 21:32:18 GMT

Try this innstead

num(SUM({<Year = {$(=Year(Today()))}, AlsisStatus = {'G','J'}>}OrderCount/6),'# ##0%')

Re: Gauge chart

Anonymous — Tue, 24 Mar 2015 21:38:26 GMT

Here is an example .qvw

Due to limited data target is set to 6 rhe expression needs to be edited to divide with 2000 when full dataset is loaded

Re: Gauge chart

Thu, 26 Mar 2015 10:52:50 GMT

I cannot download it , I have still a free edition of qlickview.

i asked to my company to have a complate version of qlickview.

we have qlickview for others factory department and I am trying to introduce for my too.

Re: Gauge chart

Anonymous — Thu, 26 Mar 2015 11:36:34 GMT

Hi,

The document only contains a Guage with the expression seen below. Depending on the amount of data loaded in your document you might want to replace the /2000 with a lower number for testing (only if you are not loading the fulle dataset.

num(SUM({<Year = {$(=Year(Today()))}, AlsisStatus = {'G','J'}>}OrderCount/2000),'# ##0%')

Re: Gauge chart

Thu, 26 Mar 2015 15:27:55 GMT

thanks for the reply , but this formula seems not work in my data.

Please see the attachment.

Thanks

Re: Gauge chart

Anonymous — Thu, 26 Mar 2015 15:47:08 GMT

It looks like you are missing a bracket in the last section after 2000 try copy past of the expression.

Re: Gauge chart

Thu, 26 Mar 2015 16:16:06 GMT

you are right, the correct formula is

=num((SUM({<Year = {$(=Year(Today()))}, AlsisScope = {'G','J'}>}CountOrder)/2000),'###0%')

but the indicator not move, it is posted on 0 yet

the indicator should be in yellow area therefore 23%...

please what could be the issue here instead?

Re: Gauge chart

Anonymous — Thu, 26 Mar 2015 17:45:10 GMT

The same expression still needs to be inside the actual "Definition" make sure that you also have corrected this expression.