Let's say we have an excel file with this structure:
In qlikview we would use a CROSSTABLE LOAD sentence to retrieve that data like:
But what happens if we don't know how much QuarterYear columns we'll have? Like here:
Will be mandatory to use the * symbol in order to load the excel crosstable like here:
If we wan't to add new Manual dimension Fields or there is more Non Crossed Dimension Fields we can do it this way:
Third CrossTable Parameter will be number of Non Crossed Dimension Fields