topic Re: How to select distinct/Unique Values in QlikView

How to select distinct/Unique Values

Mon, 26 Jan 2026 18:19:17 GMT

Hi All,

I created a report where I fetched data from oracle DB, here data which is coming is having duplicate values and I dont want to restrict it at data base level, here I need your help.

Suppose I am having 3 columns, contact_Name , Email_Address , Phone_Number. Now the phone number field is having 4 unique values for single records, e.g. Name ABC is having Mobile number, Office Number , Landline Number and Fax Number. The records looks unique but at the same time Email_Addresses are getting repeated and if I dont keep filter on Phone_Number then I will have duplicate Email Addresses which I want to avoid. How can I apply unique/Distinct filter on Email_Address coulmn in QlikView so that I can get unique values for email address in this case it doesnt matter if it ignore any of the value of Phone_Number column and use any one out of Mobile number, Office Number , Landline Number and Fax Number.

Thanks in advance.

Regards,

Abhishek

Re: How to select distinct/Unique Values

rajeshvaswani77 — Sun, 15 Sep 2013 08:45:55 GMT

HI Abhishek,

Distinct function could be helpful.

Can you post an example?

thanks,

Rajesh Vaswani

Re: How to select distinct/Unique Values

Sun, 15 Sep 2013 08:51:57 GMT

Hello,

Did you tried to use DISTINCT keyword. like only(DISTINCT email_address)

Thanks,

ASINGH

Re: How to select distinct/Unique Values

ariel_klien — Sun, 15 Sep 2013 09:03:24 GMT

Hi,

did you try max function in your table?

Ariel

Re: How to select distinct/Unique Values

Sun, 15 Sep 2013 09:07:14 GMT

I am new to QlikView so dont have much information how to do same.

Re: How to select distinct/Unique Values

rajeshvaswani77 — Sun, 15 Sep 2013 10:01:27 GMT

Hi Abhishek,

You cold also explore maxstring, firstsorted value if its relevant to your context.

thanks,

Rajesh Vaswani

Re: How to select distinct/Unique Values

Mon, 16 Sep 2013 06:28:05 GMT

Hi Below is my actual requirement, where I want to delete duplicate email address and it doesnt matter if any of the phone number get deleted I just need one phone number and remove the duplicate.

Can anyone please help me with this?

Thanks,

Abhishek

Re: How to select distinct/Unique Values

ariel_klien — Mon, 16 Sep 2013 08:08:08 GMT

Hi,

Try to put max(Phone_Number) in the expression

Ariel

Re: Re: How to select distinct/Unique Values

Mon, 16 Sep 2013 08:33:25 GMT

Hi Abhishek

You could use a Crosstable function within the load. This way, instead of loading 3 fields (Name, Email, Telephone Number), you will load 6 fields (Name, Email, Mobile Number, Office Number, Landline, Fax Number).

This way the email will only be created in one record and it will create different fields for the different phone numbers.

Alternatively, use can simply use a pivot table coupled with the max functionality. I've attached my demo qvw and source xls file.

I hope this helps.

Steve

Re: How to select distinct/Unique Values

swuehl — Mon, 16 Sep 2013 08:40:04 GMT

Try to load your data with a WHERE clause:

LOAD

Contact_Name,

Email_Address,

Phone_Number

FROM .... WHERE not EXISTS(Email_Address);

Re: How to select distinct/Unique Values

Mon, 16 Sep 2013 14:50:50 GMT

Hi Abhishek

Did the above prove to be the correct answer? I hope it at least proved useful.

Regards

Steve