topic Using Expression on Gauge Chart in QlikView

Using Expression on Gauge Chart

Anonymous — Wed, 28 Jan 2015 09:49:04 GMT

Kindly assist me with the gauge chart.

I am trying to get the total count for items from the date I would select along with the previous years and months on the database.

for example:

this is my database.

Date Items

01/01/2013 50

01/02/2013 40

04/12/2014 90

05/02/2015 85

selecting 04/12/2014, the gauge chart calculates the total Items for 04/12/2014 + 01/02/2013 + 01/01/2013 = 180

Thu, 29 Jan 2015 09:13:53 GMT

Hi Mohammed,

Please find attched QVW. It may helps you.

Thanks,

Chiru

Anonymous — Thu, 29 Jan 2015 10:50:24 GMT

Thanks a lot for help

Anonymous — Thu, 29 Jan 2015 10:54:27 GMT

Hi,

Try:

RangeSum(Above(Sum(Item),0,3))