topic Getting monthly values in QlikView

Getting monthly values

Anonymous — Thu, 05 Mar 2015 09:53:38 GMT

Hi,

my Problem is, that I only have one value per Year. Now i need one value per month (where this is only YearValue/12 for each Month).

Sure, I simply can do a

YearValue/12 as MonthValue

but i dont know how to connect this to the acutal Month.

Re: Getting monthly values

robert_mika — Thu, 05 Mar 2015 09:59:17 GMT

Do you need split that into 12 and 'see' months(Jan,Feb.....)

Re: Getting monthly values

maleksafa — Thu, 05 Mar 2015 10:02:39 GMT

can you please upload a sample document, or your schema to understand more.

also you want to do this in your load script or on the design/chart level?

Re: Getting monthly values

Anonymous — Thu, 05 Mar 2015 10:05:34 GMT

Hi Robert,

what i need is something like this:

Month	Aim	Aim cum.
Jan	0,25	0,25
Feb	0,25	0,5
Mar	0,25	0,75
Apr	0,25	1,0
May	0,25	1,25
Jun	0,25	1,5

and so on.

But I only got '3' as Aim for, lets say, Year 2014.

Re: Getting monthly values

Anonymous — Thu, 05 Mar 2015 10:07:57 GMT

Hi Malek,

I doesnt matter where i implement this. Whatever solution is easier.

Re: Getting monthly values

jagan — Thu, 05 Mar 2015 10:13:29 GMT

Hi,

Try like this using SubField

Data:

LOAD

SubField('Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec', ';') AS Month,

Value/12 AS Value

INLINE [

Value

];

Hope this helps you.

Regards,

Jagan.

Re: Getting monthly values

Anonymous — Thu, 05 Mar 2015 10:44:10 GMT

Hi Jagan,

Thx for the hint but this isnt working for me.

Problem is that i need a second dimension like department

So for one derpartment (and there are a lot) theres a plan per year. And now i need to break down this value to monthly level.

Regards,

Phil

Re: Getting monthly values

jagan — Thu, 05 Mar 2015 10:53:16 GMT

Hi,

If you share sample data it would be easier to give solution.

Hope below script helps you.

Data:

LOAD

SubField('Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec', ';') AS Month,

Department,

Year

Value/12 AS Value

FROM DataSource;

Regards,

Jagan.