topic Re: Gauge Chart Expression not display the data in QlikView

Gauge Chart Expression not display the data

Thu, 20 Sep 2012 14:05:43 GMT

Hi community members,

I have the fields costs,sales,margin in my table, and when I am trying to create a gauge chart with the expression Sum({$<Years={2007}Sales)/Sum({$1}Sales), I am unable to get the gauge chart ,it displaying the not data to display .

In the same way Sum({$<Years={2007}Costs)/Sum({$1}Costs)

Re: Gauge Chart Expression not display the data

MayilVahanan — Thu, 20 Sep 2012 14:10:56 GMT

why you using $1 in Sum({$1}Sales)? Can you say it?

$1 -> previous selection value..

Edit:

Sum({$<Years={2007}Sales)/Sum(total Sales)

This will give result..

Re: Gauge Chart Expression not display the data

jagan — Thu, 20 Sep 2012 14:24:18 GMT

Hi,

Try like this

=Sum({$<Years={2007}Sales)/Sum(TOTAL Sales)

=Sum({$<Years={2007}Sales)/Sum({1} Sales)

Hope this helps you.

Regards,

Jagan.

Re: Gauge Chart Expression not display the data

Thu, 20 Sep 2012 14:44:10 GMT

Hi I have done like this I got the below gauge chart, thanks ramasamy

Sum({$<Years ={2008}>}Sales)/Sum(Sales)

Re: Gauge Chart Expression not display the data

jagan — Thu, 20 Sep 2012 14:49:49 GMT

Hi Ramesh,

I think you missed TOTAL or {1} in the denominator of the expression.

Regards,

Jagan.

Re: Gauge Chart Expression not display the data

Thu, 20 Sep 2012 17:55:03 GMT

Thanks jagan,but I got the gauge chart correct only......I have another doubt, I have Sales field and Bill field,

when I am taking a chart with dimension as year and expression as Sum(sales), the sales bar is showing the data same as Bill field data, can you suggest me, where might be the problem

Re: Gauge Chart Expression not display the data

jagan — Fri, 21 Sep 2012 07:22:26 GMT

Hi,

Can you post sample file with explanation.

Regards,

Jagan.