how do i format a simple table?

[#1]

Hi,

I am really new to Qlikview, find it really hard to do simple formatting using table box. can someone point me to the right direction? thank you.

from

customer	contact number
Peter	95440967
Peter	04352369
Peter	123-4495

to

customer	contact number 1	contact number 2	contact number 3
Peter	95440967	04352369	123-4495
Mary	98229288	04557890	-

etc.

[Jason_Michaelides · Accepted solution]

Are there always a maximum of 3 numbers per person?

If not, look up Generic Load in the reference manual or this forum.

Hope this helps,

Jason

[#3]

Hi Jason,

I would like to have a fixed number of columns, let's assume 3 is the maximum will the solution be vastly different from generic load?

I am looking at generic load now.

[Jason_Michaelides]

Generic Load will transform the data as it is loaded.  Personally I always prefer the tall thin table type you have already.  I wonder if a slightly different solution might be better for you.  In a straight table chart add Customer as your dimension, and as an expression add:

Concat(DISTINCT [contact number],', ')

Hope this helps,

Jason

[#5]

I have implemented generic load method, and concat(distinct) as expression as you recommended.

I think the business will be more please with generic load method, but i still like my default tall-thin table.

thanks Jason!

[Jason_Michaelides]

No problem.