topic Re: Date wise Report in QlikView

Date wise Report

pkpandey — Wed, 09 Nov 2016 07:22:39 GMT

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	cGroup	Dt	Amt
A02	A2	01/06/2016	10
A02	A2	02/06/2016	20
A02	A2	03/06/2016	0
A02	A2	04/06/2016	0
A02	A2	05/06/2016	0
A02	A2	06/06/2016	0
A02	A2	07/06/2016	25
A02	A2	08/06/2016	0
A02	A2	09/06/2016	40

Re: Date wise Report

Gysbert_Wassenaar — Wed, 09 Nov 2016 07:47:15 GMT

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.

Re: Date wise Report

anushree1 — Thu, 10 Nov 2016 07:49:40 GMT

hi,

Please check if the attached Solution solves the problem