topic Re: Date selection in QlikView

Date selection

Fri, 19 Dec 2014 12:25:44 GMT

Hi experts

I have the following statement selectin values that are within the last month:

resident mitarbeiter where datum > Date(AddMonths(Today(),-1)) group by marnr;

I would like to have a statement where I only include values within the last 3 days.

Can someone help me with this?

Thanks

Jan

MarcoWedel — Fri, 19 Dec 2014 12:31:32 GMT

resident mitarbeiter where datum > Today()-3 group by marnr;

Fri, 19 Dec 2014 12:33:00 GMT

Hi Jan,

You can try the condition datum >= date(today(),-3).

Or upload the sample document.