Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm a beginner in Qlikview and would like to know if it's possible to make a boardlike this :
I have two columns in a table : name et idKey
And I woulk like to have a board like this
name idKey1 idKey2 idKey3 (etc. a number of columns idKey max or dynamically implemented)
Name | idKey1 | idKey2 | idKey3 | idKey4 |
---|---|---|---|---|
Albert | 105 | 106 | 121 | 123 |
Bertrand | 105 | 121 | ||
Charles | 106 | |||
Damien | 121 | 123 | 125 |
Instead of having this :
Name idKey
Albert 105
Albert 106
Albert 121
Albert 123
Bertrand 105
...
Thanks in advance for your reply and your time !
Please, see attached.
You could create the same quantity of expressions like the max number of IdKeys that any Name could have.
So, the show condition of each one will hide the not necesary columns that could show extra IdKey (try selecting Bertrand)
See this discussion: Re: Transaction with different products in one line
Looks like you need to use a Pivot Table Chart.
Andy
You are trying to load like this? or are you trying to view you table like this in the front end of the application?
If it is in the front end of the application, you can use the pivot table to view your table the way you are seeing it up top right now.
HTH
Best,
Sunny
Well thank you for your answers.
If it's possible to have it in the front end, I would love to only us a pivot table but I cannot find a way to have my Columns like I want... My pivot table chart only display names which have only 1 idKey not the others with several idKey...
I have to test the load script to find if it works for my case.
Please, see attached.
You could create the same quantity of expressions like the max number of IdKeys that any Name could have.
So, the show condition of each one will hide the not necesary columns that could show extra IdKey (try selecting Bertrand)
Sorry, i forgot the qvw
Hi,
Thank you so much for all your answers !
I think that it's OK for the pivot table.. It pretty looks like what I wanted.
Thank you !
I also keep the answer with the load part !