topic Gauge chart with count and date in Qlik Learning Discussions

Gauge chart with count and date

Thu, 08 Jan 2015 06:50:23 GMT

Hi All

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

Total number of open request

and similar with created date

If the created date of request is less than < 10 days it should be in green
If the created date of request more than < 10 and less than 15 days it should be in yellow
If the created date of request more < 50 it should be in red

sushil353 — Thu, 08 Jan 2015 06:58:00 GMT

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

Thu, 08 Jan 2015 07:08:14 GMT

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