How to make a special qlikview table

Wed, 25 Nov 2020 16:16:04 GMT

I have source data as below image (A) and I would like to turn the source data into qlikview format as below image (B).

Any idea how make the qlikview table into that format (B)?

Thanks

Re: How to make a special qlikview table

lironbaram — Thu, 20 Apr 2017 09:13:49 GMT

you'll need to load the table in two steps

something like

Data:

Crosstable(Type,Amount,2)

Load Product,

ProductCode,

Unit,

Value

from SourceTable;

join(Data)

Crosstable(Type,Budget,2)

Load Product,

ProductCode,

BudgetUnit,

BudgetValue

from SourceTable;