Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Author

Hi Mohammed,

Please find attched QVW. It may helps you.

Thanks,

Chiru

Anonymous
Not applicable
Author

Thanks a lot for help

Anonymous
Not applicable
Author

Hi,

Try:

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