Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

awadah25
Contributor

Using Expression on Gauge Chart

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



gauge chart - Gauge Chart - Expression/Dimension

3 Replies
Not applicable

Re: Using Expression on Gauge Chart

Hi Mohammed,

Please find attched QVW. It may helps you.

Thanks,

Chiru

awadah25
Contributor

Re: Using Expression on Gauge Chart

Thanks a lot for help

neetha_p
Honored Contributor

Re: Using Expression on Gauge Chart

Hi,

Try:

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

Community Browser