topic how do i format a simple table? in QlikView

how do i format a simple table?

Tue, 15 May 2012 07:19:38 GMT

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

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

etc.

how do i format a simple table?

Jason_Michaelides — Tue, 15 May 2012 07:22:14 GMT

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

how do i format a simple table?

Tue, 15 May 2012 07:55:00 GMT

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.

how do i format a simple table?

Jason_Michaelides — Tue, 15 May 2012 09:02:52 GMT

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

how do i format a simple table?

Tue, 15 May 2012 09:23:18 GMT

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!

how do i format a simple table?

Jason_Michaelides — Tue, 15 May 2012 09:28:44 GMT

No problem.