Concatenate table based on criteria

[qlikviewaf]

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

[marcus_sommer]

Maybe with something like:

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

- Marcus