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