Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Dynamic CrossTable Loading

   Let's say we have an excel file with this structure:

crosstable.bmp

In qlikview we would use a CROSSTABLE LOAD sentence to retrieve that data like:

crosstable1.bmp

But what happens if we don't know how much QuarterYear columns we'll have? Like here:

data.bmp

Will be mandatory to use the * symbol in order to load the excel crosstable like here:

crosstable3.bmp

If we wan't to add new Manual dimension Fields or there is more Non Crossed Dimension Fields we can do it this way:

crosstable4.bmp

Third CrossTable Parameter will be number of  Non Crossed Dimension Fields

0 Replies