Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
pkpandey
Contributor III
Contributor III

Date wise Report

Hi All

My requirement is to show the detailed data for the selected group date wise. For example when Code AO1 is selected it will show data from 01/05/2016 to 09/06/2016  continuously and for Code AO2 it will show data from 01/06/2016 to 09/06/2016 continuously. The data will show 0 for the missing dates for both the Codes as given below :

   

Code cGroupDtAmt
A02A201/06/201610
A02A202/06/201620
A02A203/06/20160
A02A204/06/20160
A02A205/06/20160
A02A206/06/20160
A02A207/06/201625
A02A208/06/20160
A02A209/06/201640
2 Replies
Gysbert_Wassenaar

See this blog post: How to populate a sparsely populated field

Only instead of using peek to get the previous value you fill in 0 as value.


talk is cheap, supply exceeds demand
anushree1
Specialist II
Specialist II

hi,

Please check if the attached Solution solves the problem