Hi,
i have a bar chart with:
- Timing on X axis
- Energy on Y axis
The same project:
- on qlikview client show me the last values order by datetime (today 21/06/2017 - show me the last 3 days: 18/06/2017-21/06/2017)
- on qlikview web show me the first values order by datetime (today 21/06/2017 - show me the first 3 days of data on the project: 25/05/2017-28/05/2017)
Can you explain me why ? I want always the focus on the last days of data as in the client
This is the expression used for the ENERGY
=Sum(Aggr( ( [DATETIME]= {"=Max([DATETIME])>Date('$(dateVisualizeInChartHour)')"}>} [ENERGY YELDED])), IDDE DAY,HOUR))