This is my first post and I would be very thankful to anyone who can help me out with this problem or perhaps point me in the right direction.
Now to the problem.
I have a table which holds asset related data. e.g
What I need to know is that, is there a way to get the data into a single row; an asset matrix
Mark - 0 - 1 - 0 - 0 - 1
Jo - 0 - 0 - 0 - 1 - 0
Gail - 0 - 0 - 1 - 0 - 0
Henry - 1 - 0 - 0 - 0 - 0
The problem is, the assets may keep increasing so hardcoding is not the solution that I'm looking for.
Though this can be achieved in SQL using a dynamic pivot, is it possible to achieve the same through QlikView or am I missing something here.
Any help is appreciated.