Hi All,
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
i>Mark,TV
ii>Mark,Fridge
iii>Jo,Notebook
iv>Gail,House
v>Henry,Car
...etc
What I need to know is that, is there a way to get the data into a single row; an asset matrix
e.g
Name-Car-Fridge-House-Notebook-TV
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.
Regards,
Pritam