Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
omyahamburg
Creator II
Creator II

generate in script 12 monthly values from a single year value

Dear All

I have a table with a lots of Years and a values.

Eg.

Year     value

2012     1200

...

I would like to generate within my script a table which

splits these values into the months:

Eg:

YearMonth     value

2012-01100
2012-02100
2012-03100
2012-04100
2012-05100
2012-06100
2012-07100
2012-08100
2012-09100
2012-10100
2012-11100
2012-12100

Can anyone tell me how to generate this ?

I hope an easy task for the experts, but I am still beginner

and appreciate your help.

Cheers

Joerg

11 Replies
omyahamburg
Creator II
Creator II
Author

Dear Jagan

Also a nice solution for me.

Thanks a lot.

Joerg

Priyanka_Mani
Contributor
Contributor

Hi,

 

Could you please share the code here. Is that using IterNo() function?

 

Thanks!