Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Note: You may notice some temporary visual or styling issues in the Community. Our vendor is actively investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
wunderch
Creator II
Creator II

autogenerate??

Hi!

I have the following problem:

I have a table like this

from Month
from Year
until Monthuntil YearBudget
0920121220125%

Now I want to create a table like this:

Month
YearBudget
0920125%
1020125%
1120125%
1220125%

Any Ideas???????

Thanks for regards

Christian

1 Solution

Accepted Solutions
Miguel_Angel_Baeyens

Hi Christian,

Use the code in this post, that uses IntervalMatch() LOAD to solve the issue.

Hope that helps.

Miguel

View solution in original post

2 Replies
Miguel_Angel_Baeyens

Hi Christian,

Use the code in this post, that uses IntervalMatch() LOAD to solve the issue.

Hope that helps.

Miguel

wunderch
Creator II
Creator II
Author

Thanks a lot Miguel!

This is exactly what I search for!