Date Range as a calulated dimension - Help Please.

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I need to add a data range as a dimension for a set of graphs featuring a number of different metrics.

I would rather not go down the set analysis route if possible.

My date field is [Date] (formatted DD/MM/YYYY) and I need to add a calculated dimension for the last 3 months based on the max [date] in the data currently loaded (which is usually yesterday).

I have tried something like:

=if([Date]>= Date(Max([Date])-100, 'DD/MM/YYYY') and [Date]<= Date(Max([Date]), 'DD/MM/YYYY'), [Date])

I know that this, if it worked, would look back 100 days but I was trying to get something close.

I have other date fields that could be used however I have two years of data so cannot only use Month or Month name without year too.

I do have a [Period] field which is a concatenate of year and month (201610) which might be better to use. Not too sure really.

Any help or suggestions would be greatly appreciated.

Thanks

Tim

topic Date Range as a calulated dimension - Help Please. in QlikView

Date Range as a calulated dimension - Help Please.