Reapeating Records

[Frquiroga1995]

Hello Everyone !

I'm new into QlikView, and now I have the following challenge:

From different data sources loaded in the script, I developed a simple table in the front part. It is kind of like this (actually it has like 12 columns):

Name	Phone	Requirement
Juan	433567	R01
Juan	458970	R01
Juan	433567	R04
Juan	458970	R04
Juan	77788765	R01
Juan	77788765	R04
Pedro	433256	R01
Pedro	433256	R06

The problem is that, for each person, there is more than one phone, and more than one requirement.

So for each phone and each requirement, I will have a record. Example: Juan has 3 different phones and 2 requirements, that means 6 records. I would like to have just one record. (Or at least, one record per requirement).

That means, I would like to have the phones in different columns (phone 1, phone 2, etc.) or I don't know if there is a way to for each client, in the phone column have like a drop down option and visualize the different phones. If that can be made also for the requirements would be great.

Thanks !

[Chanty4u]

use below for your first requirment.

https://community.qlik.com/t5/New-to-QlikView/RE-First-sorted-value/m-p/1447436

second one im not clear

[avinashelite]

Why don't you try Pivot tables? And pivot the phone number column that will show exactly how you need

[benvatvandata]

Are you trying to display this like:

If so, create a straight table chart and add Name and Requirement as dimensions. 

Then for the expressions you do:

1st Phone: =firstsortedvalue(Phone, Phone, 1)

2nd Phone: =firstsortedvalue(Phone, Phone, 2)

3rd Phone: =firstsortedvalue(Phone, Phone, 3)

etc...

[Frquiroga1995 · Accepted solution]

The thing is that a client can have one phone, 3 phone numbers, or 10 registered in the data base. 

I already solved it with a concat function, so I can visualize all the phone numbers in one row, separated with a " / " .

And having just one record per cliente.