topic Re: Qlikview Script in QlikView

Qlikview Script

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Friends,

I'm having the below table,

In this table, when the customer name is same it should have only one unique customer ID. For example the customer 'Addivant' should have only one unique customer ID but it has two IDs in the above table.

Please help how to achieve this in Qlikview script. Thanks in advance.

Re: Qlikview Script

Anonymous — Thu, 20 Apr 2017 13:12:30 GMT

How about using Min(CustomerID) while doing a group by Customer name??

Re: Qlikview Script

Anonymous — Thu, 20 Apr 2017 13:17:31 GMT

Yes Shiva, I have tried this but getting the below error script message.

Re: Qlikview Script

Anonymous — Thu, 20 Apr 2017 13:18:49 GMT

You cant use non aggregated fields in the load statement which are not present in group by clause.

Re: Qlikview Script

Anonymous — Thu, 20 Apr 2017 13:21:56 GMT

Plz help me how to achieve this Shiva.

Re: Qlikview Script

brentdej — Thu, 20 Apr 2017 15:26:46 GMT

Try change the group by statement to:

group by Customer_Name, Customer_Type, [Source Format], [Destination Format];