topic Re: Dynamic calculation of difference between values of different dates in QlikView

Dynamic calculation of difference between values of different dates

nigel987 — Tue, 18 Oct 2016 08:31:12 GMT

Hi,

I have a counter for each day, and I want to calculate the growth between the selected dates. Thus, the user shall be able to select two dates from a listbox. Is there any way to achieve this, I tried straight table, pivot tables, above function, but cannot get the correct results.

GROWTH is the column I want to receive!

id	Date	16-10-13	16-10-14	Growth
1		197	198	1
2		165	167	2
3		358	362	4
4		164	168	4
5		252	255	3
6		234	239	5
7		612	612	0
8		177	181	4
9		190	192	2
10		-	4	4

Re: Dynamic calculation of difference between values of different dates

alexis_garcia — Tue, 18 Oct 2016 08:37:39 GMT

Hi Nihal,

Try with the following expression:

Sum(Aggr(Growth),Date)

Regards.

Re: Dynamic calculation of difference between values of different dates

nigel987 — Tue, 18 Oct 2016 08:40:06 GMT

Sorry, that was misleading. Growth is the output column I want to receive.

Re: Dynamic calculation of difference between values of different dates

sunny_talwar — Tue, 18 Oct 2016 10:07:15 GMT

What are the two dates which are selected? 16-10-13 and 16-10-14? How does the raw data looks like? Would you be able to provide a sample where we can play around with this?

Re: Dynamic calculation of difference between values of different dates

nigel987 — Tue, 18 Oct 2016 12:10:15 GMT

Hi, here is the raw data file. The user shall e.g. select 13.10.2016 and 17.10.2016 and I want to compute the grwoth (delta) between those dates.

Re: Dynamic calculation of difference between values of different dates

nigel987 — Tue, 18 Oct 2016 16:20:04 GMT

Hi, has anyone a suggestion? I still cannot figure it out.

Re: Dynamic calculation of difference between values of different dates

sunny_talwar — Tue, 18 Oct 2016 20:37:07 GMT

Are you looking to get this?

Re: Dynamic calculation of difference between values of different dates

nigel987 — Tue, 18 Oct 2016 20:50:03 GMT

That was exactly what I was looking for. I need to study for solution though. Thank you Sunny!

Re: Dynamic calculation of difference between values of different dates

sunny_talwar — Tue, 18 Oct 2016 20:51:28 GMT

This will sort of only work when you have made two selections, is there a possibility for more than two selection? How would the output look like in that case?