latest data value to display on that day

[Rajesh]

Hi All,

Below is the data is generated from SQL server

Below is the data generated from Qliksense

Here the problem is the highlighted row workflow currentDay data is correct in both, but Day2,3,4,5 it is showing wrong data.

because the marked workflow runs daily 2 times and its summing up values , instead i need to display only last time ran data value

Note:  we have Date column with timestamp in the app

The data is not available for current day so i used in exp as "Today()-1 "

Can any one suggest the solution please.

Please find the attached app.

Thanks 

Rajesh