Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vitaliichupryna
Creator III
Creator III

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
sunny_talwar

1 Reply
sunny_talwar

May be you need to look here

Generating Missing Data