topic Re: Date field in QlikView

Date field

stonecold111 — Wed, 25 Nov 2020 16:16:04 GMT

Hi qliks,

I've a date dimension which has last 3 years of dates

I want to filter dates between last 2 quarters to last week

End date.

So it should filter dates start from 1st April 2017 to

5 th November 2017(last week end date).

Calculated dimension for this date????

prat1507 — Mon, 06 Nov 2017 09:48:20 GMT

Load ....

from..

where Date>=QuarterStart(Addmonths(Today(),-6))

and Date<=date(WeekStart(Today())-1)

Anil_Babu_Samineni — Mon, 06 Nov 2017 11:10:13 GMT

Perhaps this as calc. dimension

If(DateField >= QuarterStart(Addmonths(Today(),-6)) and DateField <= Date(WeekStart(Today())), DateField)

In Set Analysis, Should be like below

Sum({<DateField = {">=$(QuarterStart(Addmonths(Max(DateField),-6))) <=$(=Date(WeekStart(Max(DateField)))) "}>} Measure)

stonecold111 — Mon, 06 Nov 2017 13:18:19 GMT

Thanks.. will check.

stonecold111 — Thu, 23 Nov 2017 10:53:31 GMT

Thanks