Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Board / table in Qlikview

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)

NameidKey1idKey2idKey3idKey4
Albert105106121123
Bertrand105121
Charles106
Damien121

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 !

1 Solution

Accepted Solutions
sebastiandperei
Valued Contributor

Re: Board / table in Qlikview

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)

7 Replies

Re: Board / table in Qlikview

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


talk is cheap, supply exceeds demand
awhitfield
Esteemed Contributor

Re: Board / table in Qlikview

Looks like you need to use a Pivot Table Chart.

Andy

Re: Board / table in Qlikview

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

Not applicable

Re: Board / table in Qlikview

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
Valued Contributor

Re: Board / table in Qlikview

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
Valued Contributor

Re: Board / table in Qlikview

Sorry, i forgot the qvw

Not applicable

Re: Board / table in Qlikview

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 !

Community Browser