Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

shubham_kumar
Contributor III

How to exclude the duplicated text( In list box)

Hi,

I am taking the list box where the data is coming two times for the same item. Suppose we have two country INDIA and US then it is showing INDIA INDIA two times and US US two time.

I need only one time INDIA AND US.

best ,

skumar

2 Replies
SunilChauhan
Esteemed Contributor

How to exclude the duplicated text( In list box)

Use trim(field)

or use distinct

shubham_kumar
Contributor III

How to exclude the duplicated text( In list box)

Thank you Trim (Field ) worked