Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

vitaliichupryna
Contributor II

How build charts with gap in data?

Hi, 

I've qvd with snapshot data, small example:

 

SnapshotKeyQuantityCostDate
1105012/17/2018
1126012/18/2018
23612/17/2018
281612/18/2018
36612/17/2018
492712/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:

SnapshotKeyQuantityCostSnapShot
1105012/17/2018
23612/17/2018
36612/17/2018
492712/17/2018
Total2889 

 

But for 12/18/2018 only two

SnapshotKeyQuantityCostSnapshotDate
1126012/18/2018
281612/18/2018
Total2066 

 

Instead of this I expect to see

SnapshotKeyQuantityCostSnapshotDate
1126012/18/2018
281612/18/2018
36612/18/2018
492712/18/2018
Total 35109 

 

Thanks,

Vitalii 

Labels (2)
1 Solution

Accepted Solutions

Re: How build charts with gap in data?

1 Reply

Re: How build charts with gap in data?