topic Re: Need help with previous Quarter period in QlikView

Need help with previous Quarter period

Tue, 23 Jun 2015 10:06:44 GMT

Hi All,

I have one field period like 2015-Q1, 2014-Q4 , 2014-Q3 ... etc.

so i want current period comparison 2015-Q1 and previous period 2014-Q4 data. so any one can tell how can i achieve this ??

Thanks in advance !!

Deepak

Re: Need help with previous Quarter period

giakoum — Tue, 23 Jun 2015 10:13:33 GMT

number the periods so that you can reference the previous one in set analysis as current-1:

1 2014Q1

2 2014Q2

3 2014Q3

4 2014Q4

5 2015Q1

etc

Re: Need help with previous Quarter period

Tue, 23 Jun 2015 10:22:59 GMT

Thanks for reply but not working !!

Deepak

Re: Need help with previous Quarter period

jagan — Tue, 23 Jun 2015 10:26:45 GMT

Hi,

If you attach sample then it would be easier to provide the solution. You need to create a date field from the Quarter and then you need to use Set Analysis expression for get the previous Quarter value.

Regards,

Jagan.

Re: Need help with previous Quarter period

Anonymous — Tue, 23 Jun 2015 10:34:18 GMT

Take a look at function InQuarter(). Examples:

sum(if(InQuarter(Today(),DateField, 0), Amount)) - returns sum(Amount) for the current Quarter

sum(if(InQuarter(Today(),DateField, -1), Amount)) - returns sum(Amount) for the previous Quarter

Re: Need help with previous Quarter period

Tue, 23 Jun 2015 10:39:35 GMT

Hi Jagan,

Please find attached qvw.

Re: Need help with previous Quarter period

tresB — Tue, 23 Jun 2015 10:55:28 GMT

Ideally, this should have been taken care into the script itself by generating dual quarters. However, a workaround in the front end using string comparison, could be like in attached sample.

=sum({$<Period ={"$(=Year(QuarterStart(Date#(Period, 'YYYY-QM'),-1))&'-Q'&Ceil(Month(QuarterStart(Date#(Period, 'YYYY-QM'),-1))/3))"} >}Sales)

Re: Need help with previous Quarter period

Tue, 23 Jun 2015 11:04:57 GMT

Hi Tresesco, Thanks for help but i m not getting output which i want when i selecting any other period it not went to previous period same year.

Re: Need help with previous Quarter period

Tue, 23 Jun 2015 11:14:18 GMT

Hi Tresesco, When you do the selection 2014-Q4, than it giving the value of 2014-Q1 so earlier i said it not went to previous quarter.

Re: Need help with previous Quarter period

tresB — Tue, 23 Jun 2015 11:15:12 GMT

Sorry, corrected.

PFA

=sum({$<Period ={"$(=Year(QuarterStart(Date#(Left(Period,4)&Right(Period,1)*3, 'YYYYM'),-1))&'-Q'&Ceil(Month(QuarterStart(Date#(Left(Period,4)&Right(Period,1)*3, 'YYYYM'),-1))/3))"} >}Sales)

Re: Need help with previous Quarter period

Tue, 23 Jun 2015 13:50:08 GMT

Hi Tresesco, I need output in one single row here I am geeting two different rows.

Re: Need help with previous Quarter period

tresB — Fri, 26 Jun 2015 10:55:58 GMT

Ideally, this should have been handled in your data model. Otherwise, you have to walk an extra mile. PFA

It might look a bit complex and the approach taken is not suggested to follow unless, there is no way you can go back to the script and work on the model.