Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

vovan4ik
Valued Contributor II

Select last 3 quarters

Hi guys,

I need to select last 3 quarters.

I load the variable

dual(QuarterName(QuarterStart(date)),QuarterName(QuarterStart(date))) as QYYYY

The result is below

Capture.JPG.jpg

In expression I use set analysis

{<QYYYY={">=$(=QuarterName(QuarterStart(max(QYYYY))-100)"},AAA={1}>}

Should I use only on date level like my week selection?

{<oDate={">=$(=Date(WeekStart(date(today()))-84))"}

Thanks,

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Select last 3 quarters

Hi,

Try this

=Sum({<oDate={'>=$(=QuarterStart(Today(), -3))<=$(=QuarterEnd(Today(), -1))'}>} Sales )

Hope this helps you.

Regards,

Jagan.

1 Reply
MVP & Luminary
MVP & Luminary

Re: Select last 3 quarters

Hi,

Try this

=Sum({<oDate={'>=$(=QuarterStart(Today(), -3))<=$(=QuarterEnd(Today(), -1))'}>} Sales )

Hope this helps you.

Regards,

Jagan.

Community Browser