Gauge chart

[#1]

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

[MK_QSL]

You need to use expression as below

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

[#3]

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

But expression was defined ok from Experssion editor

[#4]

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

[Anonymous]

Hi

Try this innstead

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

[Anonymous]

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

[#7]

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.

[Anonymous]

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%')

[#9]

Hi

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

Please see the attachment.

Thanks

[Anonymous]

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