Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
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.
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
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!
No problem.