Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
raadwiptec
Creator II
Creator II

Distinct

I have the following Fields in my Source

Reference|Amount|Name|Description|Country|Domicile

I Need to have the Distinct values Only For the Below fields excluding  'description' Column. But in the Output finally I need the Description Column to be included after taking the unique values

Reference|Amount|Name|Country|Domicile 

Thanks to suggest.

1 Solution

Accepted Solutions
Kushal_Chawda

Data:
load
Reference,
Amount,
Name,
maxstring(Description) as Description
Country,
Domicile
FROM Source
Group by
Reference,
Amount,
Name,
Country,
Domicile;

View solution in original post

1 Reply
Kushal_Chawda

Data:
load
Reference,
Amount,
Name,
maxstring(Description) as Description
Country,
Domicile
FROM Source
Group by
Reference,
Amount,
Name,
Country,
Domicile;

View solution in original post