Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Qlik_User_007
Partner - Contributor
Partner - Contributor

How to code this in expression?

Hi All, 

I am new to Qlik

I have Product ID and Product Name as Follows

Product ID                                                 Product Name 

1                                                                           Colgate

1                                                                             COLGATE (US,Canada)

2                                                                             xxxx

2                                                                            yyyy (abc)

3                                                                                ddd

3                                                                                dddd (fff)

3
The above is just an example. There are 2000 different entries like that showing two/three values for Product Name With distinct ID. I am trying to extract first value for Product name where Id is distinct as shown. I am trying it in the expression.

Please HELP

Labels (3)
0 Replies