topic Create DoD comparison chart, with dates in text format? in QlikView

Create DoD comparison chart, with dates in text format?

harrywu1 — Wed, 25 Nov 2020 16:16:04 GMT

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) )

訊息由此人編輯：Harry Wu

harrywu1 — Wed, 27 Jun 2018 09:15:38 GMT

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 — Wed, 27 Jun 2018 15:37:37 GMT

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

harrywu1 — Thu, 28 Jun 2018 05:44:46 GMT

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!