Create DoD comparison chart, with dates in text format?

[harrywu1]

Hi Qlikview experts,

I've got a set of data like below, where DATE is in text format, and OUTPUT is in numbers.

I intend to create a line chart showing the DoD (Day-over-Day) change ratio, e.g. (20180624-20180623) / (20180623)

Because DATE is in text format, the date functions don't work, I assumed.

My expressions is below, but doesn't work..      Need your big hands!  Thanks~!

( sum({< DATE ={'$(=DATE)'}>} OUTPUT) - sum({< DATE ={'$(=(DATE) -1)'}>} OUTPUT) )

/

sum({< DATE ={'$(=(DATE) -1)'}>} OUTPUT) ) 

DATE	OUTPUT
20180620	28
20180621	26
20180622	27
20180623	25
20180624	27
20180625	24
20180626	29

訊息由此人編輯：Harry Wu

[harrywu1]

I just found, when a single DATE is selected, the data of the day before the selection can be found and shown.

So, looks like, now the problem lands on how to apply this to multiple DATE's..

[sunny_talwar · Accepted solution]

May be try with Inter-Record Functions

Sum(OUTPUT)/Above(Sum(OUTPUT)) - 1

[harrywu1]

Thank, Sunny!  It works!

This performs like a data offset, shifting previous or later data to become a new set of data of current day.

Also, the reference Inter-Record Functions you provided gave me a new idea that Qlikview can do for data shift for creating charts.  

Thanks a million!