How build charts with gap in data?

vitaliichupryna — Sat, 16 Nov 2024 04:56:25 GMT

Hi,

I've qvd with snapshot data, small example:

SnapshotKey	Quantity	Cost	Date
1	10	50	12/17/2018
1	12	60	12/18/2018
2	3	6	12/17/2018
2	8	16	12/18/2018
3	6	6	12/17/2018
4	9	27	12/17/2018

I need build charts that will show how quantity and cost changed by date field. My problem is that snapshot table contains only changes, so for date 12/17/2018 I have data for all keys:

SnapshotKey	Quantity	Cost	SnapShot
1	10	50	12/17/2018
2	3	6	12/17/2018
3	6	6	12/17/2018
4	9	27	12/17/2018
Total	28	89

But for 12/18/2018 only two

SnapshotKey	Quantity	Cost	SnapshotDate
1	12	60	12/18/2018
2	8	16	12/18/2018
Total	20	66

Instead of this I expect to see

SnapshotKey	Quantity	Cost	SnapshotDate
1	12	60	12/18/2018
2	8	16	12/18/2018
3	6	6	12/18/2018
4	9	27	12/18/2018
Total	35	109

Thanks,

Vitalii

Re: How build charts with gap in data?

sunny_talwar — Tue, 18 Dec 2018 12:25:45 GMT

May be you need to look here

Generating Missing Data

topic How build charts with gap in data? in QlikView

How build charts with gap in data?

Re: How build charts with gap in data?