How to merge several columns into one?

[kfahri342]

Hi All,

In my underlying data, I have a table like the following:

ID	Phase 1	Phase 2	Phase 3	Phase 4	Phase 5
System A	Sept-17	Oct-17	Nov-17	Dec-17	Mar-18
System B	Nov-17	Dec-17	Jan-18	Feb-18	Mar-18
System C	Aug-17	Sept-17	Oct-17	Nov-17	Dec-17

And for a particular view, I need to transpose the data into the below structure on Qlikview;

Unfortunately, I am unable to change the structure of the underlying data, so I am hoping I can manipulate the expression & dimensions to create the desired view.

Any ideas are welcome?

Many Thanks

Kozan

Type of Phase	Aug-17	Sep-17	Oct-17	Nov-17	Dec-17	Jan-18	Feb-18	Mar-18
Phase 1	1	1		1
Phase 2		1	1		1
Phase 3			1	1		1
Phase 4				1	1		1
Phase 5					1			2

I fgdfgdfgdf

[kfahri342]

That dimension doesn't appear. I do get a whole load of dates in my dimensions now [e.g Jan 2017, Jan 2018, Jul 2017 etc.]. ???

[kfahri342]

That is not the issue. My underlying data has the dates as a Number [e.g. 42767 = Feb 2017].

[kfahri342]

Bump