Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

kshitijas
New Contributor III

Guage Chart

Hello Community,

How can i show the following exampe in a guage chart?


Eg.

if we want to show the results of this year revenue against last year revenue

for eg.

lat years revenue was 100 inr

and this years revenue so far is 80 inr

then its 80% so far

but lets say by dec this years revenue becomes 125 inr

then we have achieved 125% so far this year.

Thanks in advance!

Tags (1)
3 Replies
arvind_patil
Valued Contributor II

Re: Guage Chart

Hi Kshitija,

You can write set expression for revenue

Sum(<Year={'$(=Max(year)'}>}Revenue)/Sum(<Year={'$(=Max(year)-1'}>}Revenue)


In presentation tab Check Show %

Thanks,

Arvind Patil

kshitijas
New Contributor III

Re: Guage Chart

Hi Arvind,

Thanks for the reply , but the expression is not working!

Thanks,

Kshitija Shinde

kulwantsaj219
Contributor II

Re: Guage Chart

Capture.PNG

=num(sum({<year={$(=max(year))}>}rev)/

sum({<year={$(=max(year)-1)}>}rev),'####%')