Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have a excel file in the below format .
S.No FundName 2018 Assets 2019 Assets 2018 Subscribers 2019 Subscribers
i have to convert the source into below format
S.No FundName Year Assets Subscriobers
Need your help on this
You could use two Crosstable-Loads - one for Assets and one for Subscribers - and then joining them together.
1) Load the columns in separate loads
2) Create the Year column with the year value
3) rename the columns so that they can automatically concatenate.
See example below:
'2018' as Year,
2018 Assets as Assets,
2018 Subscribers as Subscribers
'2019' as Year,
2019 Assets as Assets,
2019 Subscribers as Subscribers