topic seting a default value to gauge chart in QlikView

seting a default value to gauge chart

sunil2288 — Fri, 09 Apr 2010 12:08:18 GMT

HI All,

I am using a gauge chart to display some data.But after clearing all the selection it is pointing out to the last data value of the list. how can i point the niddle to default value '0'

Reply Awaited

Thanks

Sunil

seting a default value to gauge chart

amars — Fri, 09 Apr 2010 12:24:38 GMT

Hi Sunil,

Gauge chart's are to display a single value such as % (i.e Attrition, hiring etc like that). If u r using a gauge chart for showing multiple values, it is not possible for a gauge to show multiple values.

with Regards

Amar

seting a default value to gauge chart

Fri, 09 Apr 2010 12:32:11 GMT

Hi Sunil,

In Gauge charts, we don't use any dimensions. We only use the calculated expression to reflect values in these kind of charts. Now I am not clear with your question. But I think you have used dimensions in this chart. hope this helps you.

Best Regards

seting a default value to gauge chart

sunil2288 — Fri, 09 Apr 2010 12:38:41 GMT

hi all

I am using years as dimension and sum(sales) as expression. the niddle always shows to the last value of "years" after clearing all the selection. i want to set it to default value '0' after clearing all the selection.

comments highly appreciated

Thanks

seting a default value to gauge chart

sunil2288 — Fri, 09 Apr 2010 12:41:05 GMT

Why can't we use dimensions..After using a dimension it also working for a particular selection. that is the niddle pointing to a selected dimensional value.

seting a default value to gauge chart

skaredovs — Fri, 09 Apr 2010 13:23:13 GMT

Hi, Sunil!

Gauge chart just ignores dimensions.

In you case I would recomment to use IF in the expression

if(isnull(getcurrentselections ()), 0,Sum (sales))

seting a default value to gauge chart

kji — Fri, 09 Apr 2010 13:30:20 GMT

The Gauge chart does not ignore dimensions, what it does is that it displays the value of the first enabled expression on the first row of data.