Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

aut_phil
Contributor

Getting monthly values

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.

7 Replies

Re: Getting monthly values

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

maleksafa
Valued Contributor

Re: Getting monthly values

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?

aut_phil
Contributor

Re: Getting monthly values

Hi Robert,

what i need is something like this:

MonthAimAim cum.
Jan0,250,25
Feb0,250,5
Mar0,250,75
Apr0,251,0
May0,251,25
Jun0,251,5

and so on.

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

aut_phil
Contributor

Re: Getting monthly values

Hi Malek,

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

MVP
MVP

Re: Getting monthly values

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

    6

    3

    10

];

Hope this helps you.

Regards,

Jagan.

aut_phil
Contributor

Re: Getting monthly values

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

MVP
MVP

Re: Getting monthly values

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.

Community Browser