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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
jordan231
Contributor II
Contributor II

cross table dynamic date

Hi , i cant figure that out so maybe you can help me with that . 
I have a data set i'm trying to convert into table with crosstable function

I have a product list , every column represent next months. and values inside. 

jordan231_0-1695370268621.png

 

I managed to have good strucutre but i would like to make also a dates for every record on the fly.  
I can do that with resident load but maybe there is a better way ? Any ideas ? thanks ! 

Labels (1)
1 Solution

Accepted Solutions
anat
Master
Master

tab:
CrossTable(col1,col2)
load * Inline [
c1,1,2
A,5,6
B,8,9

];

NoConcatenate
LOAD *,AddMonths( Today(),num#(col1)) as Mth Resident tab;
DROP Table tab;

View solution in original post

1 Reply
anat
Master
Master

tab:
CrossTable(col1,col2)
load * Inline [
c1,1,2
A,5,6
B,8,9

];

NoConcatenate
LOAD *,AddMonths( Today(),num#(col1)) as Mth Resident tab;
DROP Table tab;