Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
robert_mika
Master III
Master III

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

maleksafa
Specialist
Specialist

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?

Anonymous
Not applicable
Author

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.

Anonymous
Not applicable
Author

Hi Malek,

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

jagan
Luminary Alumni
Luminary Alumni

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.

Anonymous
Not applicable
Author

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

jagan
Luminary Alumni
Luminary Alumni

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.