Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everybody,
I have data in excel which is arranged in the following format:
Initiative 1 | Initiative 2 | Initiative 3 | Initiative 1 | Initiative 2 | Initiative 3 | |
Sl.No. | Brand 1 | Brand 1 | Brand 1 | Brand 2 | Brand 2 | Brand 2 |
1 | ||||||
2 | ||||||
3 |
And I want to convert it into a format which should look like this:
Sl.No. | Initiatives | Brand |
1 | Initiative 1 | Brand 1 |
1 | Initiative 2 | Brand 1 |
1 | Initiative 3 | Brand 1 |
1 | Initiative 1 | Brand 2 |
1 | Initiative 2 | Brand 2 |
1 | Initiative 3 | Brand 2 |
2 | Initiative 1 | Brand 1 |
2 | Initiative 2 | Brand 1 |
2 | Initiative 3 | Brand 1 |
2 | Initiative 1 | Brand 2 |
2 | Initiative 2 | Brand 2 |
2 | Initiative 3 | Brand 2 |
3 | Initiative 1 | Brand 1 |
3 | Initiative 2 | Brand 1 |
3 | Initiative 3 | Brand 1 |
3 | Initiative 1 | Brand 2 |
3 | Initiative 2 | Brand 2 |
3 | Initiative 3 | Brand 2 |
While I am able to do it in the excel I was wondering if it would be possible to do it in Qlik Sense also?
Thank You in Advance
Hi
Try using Crosstable while loading the data in the script editor
Hope this helps
Thanks