Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

Gauge chart with count and date

Hi All

Can you please help me how we configure a Gauge chart for the below scenario

Total number of open request

  1. If the count request is less than < 10 it should be in green
  2. If the count request is more than < 10 and less than 50 it should be in yellow
  3. If the count request is more than < 50  it should be in red

and similar with created date

  1. If the created date of request is less than < 10 days  it should be in green
  2. If the created date of request more than < 10 and less than 15 days  it should be in yellow
  3. If the created date of request more   < 50  it should be in red
Tags (1)
2 Replies
sushil353
Honored Contributor II

Re: Gauge chart with count and date

Hi,

1. Create the expression for your count.

2. Presentation tab> set Min as 1 and max say 100

3. uncheck Autowidth segment from lower left corner

4. Create three segment with the relevant color having lower bound as

Segment 1 --> 0

Segment 2--> 10

segment 3 --> 50

HTH

Sushil

Not applicable

Re: Gauge chart with count and date

Thanks Sushil.Your suggestion was great help  .Can you please help with Create date scenario also.

Community Browser