topic Re: Max Gauge Setting in QlikView

Max Gauge Setting

Anonymous — Mon, 11 Nov 2013 18:27:09 GMT

Hi guys,

I have an expression

Count([VarA])/

Count(ALL [VarA]).

What the expression I can add to get max value in the gauge settings?

Thanks,

israrkhan — Mon, 11 Nov 2013 18:56:01 GMT

to get the max value use max function like Max(value), if value is string then use maxstring(value)..

Count([VarA]) / Count(ALL [VarA]). this expression count the Value for selected Dimensions/Total value,

Total Used for ignoring dimensions...

But Gauge chart usually used for showing a total count or total sum of a value, without dimensions,

dimension groups the data, so Gauge chart is not useful if you want to group data, then use Pie Chart Instead.

Hope to help....

Anonymous — Mon, 11 Nov 2013 19:01:07 GMT

Hi,

The results in % is not big, I'd like to use automatic define max value for axis

Regards,

Anonymous — Mon, 11 Nov 2013 19:59:10 GMT

Hi Vladimir,

Please find the attachment of application,i think your issue is resolved,please let me know if you have any issue.

Regards

Anonymous — Mon, 11 Nov 2013 20:16:53 GMT

Thanks!!!!