topic Re: How to Compare data Year Wise in gauge chat in QlikView

How to Compare data Year Wise in gauge chat

Mon, 24 Sep 2012 20:04:33 GMT

Hi community members,

How to compare the current and previous years sales in gauge chart

Regards,

Ramesh

MayilVahanan — Mon, 24 Sep 2012 20:26:33 GMT

Gauge charts are used to display the value of a single expression without dimensions.

So its not used for compare the sales report in same gauge chart..You can use pie or bar chart for compare

Mon, 24 Sep 2012 20:31:51 GMT

Hi ramasamy,

I want to display in two charts , one with current select and the other with previous years, is it possible

regard

ramesh

MayilVahanan — Mon, 24 Sep 2012 20:36:12 GMT

ya,it possible..

Mon, 24 Sep 2012 21:21:55 GMT

please tell me how to write the script or in gauge chart

MayilVahanan — Mon, 24 Sep 2012 21:34:29 GMT

No dimension:

1st gauge:

Exp:

=Sum({<Year = {'=$(=max(Year)-1)'}>}SalesTest) for max(year)-1

2nd gauge:

Exp:

=Sum({<Year = {'=$(=max(Year))'}>}SalesTest) for max(year)

Mon, 24 Sep 2012 22:44:52 GMT

I am not getting the comparison ,just showing the gauge with needle showing a max point,will you please help me

regards,

rams

MayilVahanan — Mon, 24 Sep 2012 23:24:20 GMT

Its just show the values in gauge chart.. Use gauge chart for percentage calculation purpose.. Please use any other chart instead of it.