Board / table in Qlikview

[#1]

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 !

[Gysbert_Wassenaar]

See this discussion: Re: Transaction with different products in one line

[awhitfield]

Looks like you need to use a Pivot Table Chart.

Andy

[sunny_talwar]

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

[#5]

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.

[sebastiandperei · Accepted solution]

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)

[sebastiandperei]

Sorry, i forgot the qvw

[#8]

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 !