topic AW:Gauge Chart Problem? in QlikView

Gauge Chart Problem?

Thu, 24 Jun 2010 09:19:36 GMT

Hi;

in my database 1. column is Gender(value is "E" or "F")
2. column is customer_name(e.g. "John")

I would like to count and show male and female customers in Gauge Chart. I try it but I failed...

Any idea about this problem ?

Thanks in Advance...

brenner_martina — Thu, 24 Jun 2010 09:35:16 GMT

Hi,

what do you want to show in the gauge chart? Percentage of "E" or "F"? Percentge "E" of all? Percentage "F" of All?

Put the expression:

(Sum(If(gender='E',1,0))/Sum(If(gender='F',1,0))

(Count(All) - Sum(If(gender='E',1,0))) / Count(All)

or (Count(All) - Sum(If(gender='F',1,0))) / Count(All)

Thu, 24 Jun 2010 09:37:30 GMT

Use 3 expressions in your gauge chart:

1: Total count of customers

2: Count of customers where gender is F

3: 2/1

Promote expression 3 to be the first expression shown

That should work, i guess

Thu, 24 Jun 2010 13:38:25 GMT

Thank you for responses.

All of them are working correctly...