Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
jordan231
Contributor
Contributor

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;