topic Re: Last quarter in QlikView

Last quarter

Tue, 20 Oct 2015 09:32:00 GMT

Hello,

I need to make appear the last quarter from my selection:

QuarterAndCumul:

LOAD Year,

information1,

information2,

information3,

information4,

Date(MakeDate(Left(Year,4),(Right(Year,1)-1)*3+1,1)) as Quarter

FROM

QnC.qvd

(qvd);

==================================================

I desire when I select "2000_Q2" a table show 2000_Q1's informations and 2001_Q4 with the same table 2001_Q3's information

Thanks for your help

Regards

marcus_sommer — Tue, 20 Oct 2015 12:56:38 GMT

I think I would try it with an additionally numeric year-field (here are two versions) and set analysis:

Load

...

// left(Year,4) * 10 + right(Year,1) as YearNum, // will be more complicated because it's not linear

if(rowno() = 1, 1, if(Year = peek('Year'), peek('YearNUM'), peek('YearNUM') + 1)) as YearNum,

...

and as expression something like:

sum({< YearNum = {">=$(=max(YearNum) - 1)<$(=max(YearNum) + 2)"}>} Information)

The bolded parts might be adjusted to your needs.

- Marcus