topic Re: Month Range in QlikView

Month Range

Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I am trying to group the months in range with the below label. Thank you for help!

for example;

1-3

4-6

7-9

10-12

Re: Month Range

Wed, 27 Jul 2016 20:36:21 GMT

you can do this on dimension, with if, if(month_field <3,'<3',.... but have a calculed dimension is not good.

i sugery create a group on scrip witch apllymap

map_month:

maping load * inline [

month,group´

1,<3

2,❤️

3,❤️

4,4-6

5,4-6

6,4-6

7,7-9

8,7-9

9,7-9

10,10-12

11,10-12

12,10-12

];

load month,

applymap('map_month',month) as group_mont

from ...

Re: Month Range

sunny_talwar — Wed, 27 Jul 2016 20:38:05 GMT

May be like this:

If(Month < 3, Dual('1-3', 1),

If(Month < 6, Dual('4-6', 2),

If(Month < 9, Dual('7-9', 3), Dual('10-12', 4))))

Re: Month Range

swuehl — Wed, 27 Jul 2016 20:38:31 GMT

Are you trying to group your months in quarters?

What would <1 denote then?

If you want to group your months in quarters, create a quarter field in the load script, e.g. using

LOAD DateField,

Month(DateField) as MonthField,

Ceil(Month(DateField)/3) as Quarter,

...

Re: Month Range

Wed, 27 Jul 2016 20:43:31 GMT

<1 would be less then a month

Re: Month Range

Wed, 27 Jul 2016 20:45:54 GMT

Re: Month Range

Wed, 27 Jul 2016 20:47:31 GMT

it should display like the picture below

Re: Month Range

Wed, 27 Jul 2016 20:48:47 GMT

Hi Sunny,

It should look as shown in the print screen below

Re: Month Range

swuehl — Wed, 27 Jul 2016 21:05:19 GMT

Less than a month? Wouldn't this apply if you are considering a time intervals only, while months / quarters are denoting more like point in times (with more / less granularity)?