Concatenate table based on criteria

qlikviewaf — Wed, 18 Jul 2018 14:39:44 GMT

HI,

i have a TableC that i would like to concatenate to my Master Sales Table.

I would like to concatenate based on a criteria which follows:

if Day (based on Today date) is between 1-3 then load all data from TableC where SalesDate> Month Start Date of the previous month
if Day (based on Today date) is between 5-31 then load all data from TableC where SalesDate> Month Start Date of the current month

Which is the right syntax to do this?

Thank you

Re: Concatenate table based on criteria

marcus_sommer — Thu, 19 Jul 2018 12:17:44 GMT

Maybe with something like:

load * from TableC where SalesDate >= monthstart(today(), (day(today())<=3));

- Marcus