Using above() in a chart and making selections

[lerouxlarissa]

Hi All, 

I want to make a bar chart showing daily electricity consumption. The value pulled in from the data source is an accumulating value of the total electricity usage for the building.

I then use 

Max( {<SensorMeasure = {'Electricity'}>} Aggr(Max(Value), EntryTime)) - Above( Max( {<SensorMeasure = {'Electricity'}>} Aggr(Max(Value), EntryTime)) )

to calculate the daily increments.  (See image 1). 

Then I plot the daily usage on a bar char (See image 2)

But when I make selections on the bar chart, it only shows the day after the first selected date (due to the chart looking for an 'above'  value) (See image 3)

Does anyone know if there is a work-around for this? or if there is an alternative way of displaying the same results without using above()? 

Thanks

[avinashelite]

You could use TOTAL key word ... not sure about your requirement ...

I think best way is to create an As of table , check the below link 

https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130