Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have requirement like Matrix layout output, how to achieve this in qlikview? Thanks
Source file | ||
---|---|---|
Date | Customer | Rating |
31/08/2016 | A | 10 |
31/08/2016 | B | 10 |
31/08/2016 | C | 5 |
31/08/2016 | D | 5 |
31/08/2016 | E | 10 |
31/08/2016 | F | 10 |
31/08/2016 | G | 10 |
31/08/2016 | H | 4 |
31/08/2016 | I | 6 |
31/07/2016 | A | 8 |
31/07/2016 | B | 2 |
31/07/2016 | C | 3 |
31/07/2016 | D | 3 |
31/07/2016 | E | 8 |
31/07/2016 | F | 8 |
31/07/2016 | G | 8 |
31/07/2016 | H | 10 |
31/07/2016 | I | 7 |
Note: | ||||||||
Grade | customer count | |||||||
Previous Month | always show the previous month as top of the migration matrix e.x: 31/Jul/2016 | |||||||
Current Month | Current month to be shown in left of the matrix e.x: 31/Aug/2016 |
Thanks dev
Like this?
Would you provide application.
OR Do transpose after creating PIVOT
Like this?