Dynamic CrossTable Loading

Thu, 03 Oct 2013 07:20:29 GMT

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

topic Dynamic CrossTable Loading in Español