visualize changes in data based on previous date

Wed, 21 Sep 2016 12:08:46 GMT

Hi All,

I need to visualize (table) two keyfigures and their change over time, based on one Dimension.

This is These Points were you see a Change in a line Chart for example.

I tried to solve it with previous() and peek() in the script, with before(), above() to query the values from the date loaded before... but could not manage to get it running. Data should always be compared to the previous date loaded.

data is available always for today and today-1 (to -4) weeks.

Data example:

Dimension1	Date	Value1	Value2
A	27.08.2016	30	20
A	03.09.2016	30	20
A	10.09.2016	40	10
A	17.09.2016	40	20
B	27.08.2016	10	10
B	10.09.2016	20	30
B	17.09.2016	20	30

The result should show e.g. that keyfigure "Value1" for Dimension "A" changed from 30 on 03.09. to 40 on 10.09.

possible Result:

Dimension1	Keyfigure	ChangeFromDate	ChangeFrom	ChangeToDate	ChangeTo
A	Value1	03.09.2016	30	10.09.2016	20
A	Value2	03.09.2016	40	10.09.2016	10
A	Value2	10.09.2016	10	17.09.2016	20
B	Value1	27.08.2016	10	10.09.2016	20
B	Value2	27.08.2016	10	10.09.2016	30

any help appreciated!

topic visualize changes in data based on previous date in QlikView

visualize changes in data based on previous date