Date field

Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

i am using four files as source to create a report,

one is the weekly generated file, remaining three are daily generated files.

so i want to show the report based on weekly generated report date. How can i remove or supress the remaining dates

exapmple: first file, aug10,aug18, aug25,aug31

second,third and fourth files: aug1,aug2,aug3,aug4.......aug31

all the dates are not required for the report, only first file dates data want to show.

all the files are having date fields,

what i have done is created a variable and assigned the weekly file date Field to it and used where condition to the remaining three files that the date should equals to variable value.

i am getting blank report

pls help me..

Thanks,

Sowmya

Re: Date field

tresB — Fri, 26 Aug 2016 07:24:55 GMT

Probably three things could give you what you need.

-Create a logic for Week definition

-Aggregate the daily values to get the weekly values based on that logic

-Associate the files on week.

topic Date field in QlikView

Date field

Re: Date field