topic Re: Reapeating Records in QlikView

Reapeating Records

Frquiroga1995 — Sat, 16 Nov 2024 17:59:31 GMT

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 !

Re: Reapeating Records

Chanty4u — Sat, 10 Oct 2020 05:32:21 GMT

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

Re: Reapeating Records

avinashelite — Sat, 10 Oct 2020 07:34:02 GMT

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

Re: Reapeating Records

benvatvandata — Fri, 16 Oct 2020 17:46:38 GMT

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...

Re: Reapeating Records

Frquiroga1995 — Fri, 16 Oct 2020 17:54:08 GMT

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.