topic Re: Value Difference between dates in QlikView

Value Difference between dates

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

Hi there,

Need help calculating out the below.

I have a table like below:

Serial	Consum	18/12/17	17/12/17	16/12/17	15/12/17	01/12/17
123456AT12	8008AABT	35.4%	37.9%	37.9%	41.0%	42.7%
123456AT12	8007TERA	88.1%	89.4%	92.1%	93.0%	93.0%
45012AREG	8000ERAN	10.0%	10.0%	10.5%	11.1%	12.3%

I need to calculate the difference between each date.

Example for line 1: (18/12/17) 35.4% & (17/12/17) 37.9% = 2.5% Difference.

But then I need to do this for every report date. So compare 18th& 17th, 17th&16th, 16th&15th and so on.

Once I've got the differences, I will then build a daily average.

Can anyone please advise?

Thanks

Craig

Re: Value Difference between dates

sunny_talwar — Mon, 18 Dec 2017 14:08:11 GMT

May be like this

Column(1) - Before(Column(1))

Re: Value Difference between dates

craig157 — Mon, 18 Dec 2017 14:50:20 GMT

Hi Sunny,

Gave it a go but it's bringing back strange figures.

example data:

18/12/17 17/12/17

69.0% 70.0%

The result came through as 150!!

Re: Value Difference between dates

sunny_talwar — Mon, 18 Dec 2017 14:51:10 GMT

Would you be able to share a sample?

Re: Value Difference between dates

daveamz — Mon, 18 Dec 2017 15:45:12 GMT

Hi Craig,

Something like this?

Regards,

David

Re: Value Difference between dates

craig157 — Mon, 18 Dec 2017 16:09:50 GMT

Hi Sunny, ignore my previous comment - I didn't realise there was some Unit Conversion for percentage I missed from my expression until I tested it outwith this particular project!

Thanks for your help, I had never heard of the Before / After Function before today!

Thanks,

Re: Value Difference between dates

craig157 — Mon, 18 Dec 2017 16:10:05 GMT

Thanks David! Extremely helpful!

Re: Value Difference between dates

sunny_talwar — Mon, 18 Dec 2017 16:10:53 GMT

You can check them here, if you have not already seen this

Missing Manual - Before() and After()