Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

regarding the column distinct feature

Want to disaply the distinct  data like this

I have column like  country  is

IND

IND;#ENG;#PAK

ENG;#WES

AUS;#IND

IND;#BAN:AUS

i want to display

IND

ENG:#PAK(since IND already came)

WES(Since ENG alrraedy came)

Please suggest me the solution

3 Replies
santiago_respane
Specialist
Specialist

Hi Thiru,

Do you mean that you want the records to appear only if they where previously loaded?

please can you elaborate more?

Kind regards,

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Temp:

LOAD ID, Country Where Not Exists(Country);

LOAD SubField(Country,';#') as Country, RecNo() as ID INLINE [

Country

IND

IND;#ENG;#PAK

ENG;#WES

AUS;#IND

IND;#BAN;#AUS

];

Result:

LOAD Concat(Country, ';#') as Country Resident Temp Group By ID;

Drop Table Temp;


talk is cheap, supply exceeds demand
Not applicable
Author

Hi Santigo,

I have a field called country    so i crated a multi box as a filter,when i select more then any value from multi box

then i have  on more text box is there in dashboard

Country -----------------------

here it has to show

IND

ENG:#PAK(since IND already came)

WES(Since ENG already  came)

but actual is

IND

IND;#ENG;#PAK

ENG;#WES

AUS;#IND

IND;#BAN:AUS

so how to get that

Please do the needful