topic want to create customised month dimension? in QlikView

want to create customised month dimension?

rupaliqlik — Tue, 05 Jul 2016 17:50:21 GMT

Hi Expert,

In my application i want to create customised month dimension which contains all the month names,quarters, and YTD calculation.Please tell me how to make this.Is it possible ?

Re: want to create customised month dimension?

vinieme12 — Tue, 05 Jul 2016 18:59:40 GMT

I believe you need a master calendar

Creating A Master Calendar

Re: want to create customised month dimension?

johnw — Tue, 05 Jul 2016 19:01:58 GMT

Yes, it's possible. Build a table that looks something like this, and use Month Group as your dimension.

Month Group, Month
2015, Jan-15
2015, Feb-15
...
2015, Dec-15
2016 YTD, Jan-16
...
2016 YTD, Jul-16
...
Q1 2015, Jan-15
Q1 2015, Feb-15
Q1 2015, Mar-15
...
Jan-15, Jan-15
Feb-15, Feb-15
Mar-15, Mar-15
...

Let me know if you need help building this table. You wouldn't do it as an inline load. I'm just showing what you'd want the data to look like.

Re: want to create customised month dimension?

rupaliqlik — Thu, 07 Jul 2016 08:57:57 GMT

Hi John,

I want dimension like this

Jan-15

Feb-15

Mar-15

Apr-15

May-15

Jun-15

Jul-15

Aug-15

Sep-15

Oct-15

Nov-15

Dec-15

Jan-16

Feb-16

Mar-16

Apr-16

May-16

Jun-16

Jul-16

YTD Actual

.So user can see monthwise, quarterwise and ytd wise business in one shot.

Re: want to create customised month dimension?

vinieme12 — Thu, 07 Jul 2016 16:52:26 GMT

Please refer the link

Period Presets: Compare Periods on the fly

Re: want to create customised month dimension?

johnw — Thu, 07 Jul 2016 18:25:44 GMT

"I want dimension like this...So user can see monthwise, quarterwise and ytd wise business in one shot."

Yes, I understood that, and what I posted is one way to create that dimension. It also pretty much matches what Vineeth posted. My "Month Group" is his "Period", and he's linking to dates instead of to months, but it's the same basic idea, and a way of creating the linkage table that I'm going to need to remember. I don't think I ever used crosstable to do it, but that seems like such a simple, elegant solution. Thanks, Vineeth!

Re: want to create customised month dimension?

vinieme12 — Sat, 09 Jul 2016 07:02:07 GMT

Hi Rupali,

Can you close this post now?

Re: want to create customised month dimension?

MarcoWedel — Sat, 09 Jul 2016 23:51:58 GMT

Hi,

maybe one solution could be a pivot table with month, quarter and year dimensions and partial sums:

hope this helps

regards

Marco