Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.]. ???
That is not the issue. My underlying data has the dates as a Number [e.g. 42767 = Feb 2017].
Bump