topic Re: Board / table in Qlikview in QlikView

Board / table in Qlikview

Thu, 23 Apr 2015 13:12:06 GMT

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 !

Re: Board / table in Qlikview

Gysbert_Wassenaar — Thu, 23 Apr 2015 13:28:34 GMT

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

Re: Board / table in Qlikview

awhitfield — Thu, 23 Apr 2015 13:29:27 GMT

Looks like you need to use a Pivot Table Chart.

Andy

Re: Board / table in Qlikview

sunny_talwar — Thu, 23 Apr 2015 13:31:16 GMT

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

Re: Board / table in Qlikview

Thu, 23 Apr 2015 13:41:36 GMT

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.

Re: Board / table in Qlikview

sebastiandperei — Thu, 23 Apr 2015 14:01:05 GMT

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)

Re: Board / table in Qlikview

sebastiandperei — Thu, 23 Apr 2015 14:01:46 GMT

Sorry, i forgot the qvw

Re: Board / table in Qlikview

Thu, 23 Apr 2015 15:04:38 GMT

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 !