Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Gauge Chart Problem?

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...

Tags (1)
1 Solution

Accepted Solutions
Highlighted
Partner
Partner

AW:Gauge Chart Problem?

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)

View solution in original post

3 Replies
Highlighted
Partner
Partner

AW:Gauge Chart Problem?

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)

View solution in original post

Highlighted
Not applicable

Gauge Chart Problem?

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

Highlighted
Not applicable

AW:Gauge Chart Problem?

Thank you for responses.

All of them are working correctly...