topic quarters mapping without dates in QlikView

quarters mapping without dates

Mon, 28 Sep 2015 07:36:49 GMT

Hi,

new to qlikview and still trying to get a handle on it. I have some data which do not have dates only years and quarters. Trying to manipulate the data so I can show some historical charts. However, how do I enable qlikview to recognize that with quarters after q4 it should count the next quarter as q1? For instance if I want to show current quarter as 2015 Q3 and I want to reference 2014 Q4, I could say

current year & current quarter - 3

However, I'm getting 2015 Q0.

I've used the master calendar before, however I want to know if there is a short cut version for qlikview to recognize the above.

Thanks,

Carlo

Re: quarters mapping without dates

Gysbert_Wassenaar — Mon, 28 Sep 2015 07:48:07 GMT

You can create a table first in the script that creates Quarter values that also have a numeric value:

Quarters:

LOAD dual(Quarter, RowNo()) as Quarter [

Quarter

2012 Q1

....etc

2014 Q3

2014 Q4

2015 Q1

etc..

];

Or perhaps you can create the Quarters as date values:

LOAD

Year,

Quarter,

MakeDate(Year, Quarter*3-2) as QuarterStart,

....other fields...

FROM ....

Re: quarters mapping without dates

pratap6699 — Mon, 28 Sep 2015 09:56:15 GMT

in script level: Load year, quarter,year & quarter as yearquarter from source

UI--> barchart-->dim-->yearquarter exp-->

sum({<yearquarter={">=$(=Min(yearquarter)<=$(=Min(yearquarter)-3))}>}amount)

Re: quarters mapping without dates

MarcoWedel — Mon, 28 Sep 2015 23:58:37 GMT

Hi,

maybe also helpful:

LOAD *,
    Dual(Year&' '&Quarter, MakeDate(Year,Quarter*3-2)) as QuarterName;
LOAD Left(Quarter,4) as Year,
    Dual(Right(Quarter,2),Right(Quarter,1)) as Quarter
INLINE [
    Quarter
    2015 Q4
    2015 Q3
    2015 Q2
    2015 Q1
    2014 Q4
    2014 Q3
    2014 Q2
    2014 Q1
    2013 Q4
    2013 Q3
    2013 Q2
    2013 Q1
];

regards

Marco