Date field

[stonecold111]

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]

Load ....

from..

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

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

[Anil_Babu_Samineni · Accepted solution]

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]

Thanks.. will check.

[stonecold111]

Thanks