topic Re: regarding the column distinct feature in QlikView

regarding the column distinct feature

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: regarding the column distinct feature

santiago_respane — Wed, 09 Mar 2016 15:22:22 GMT

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,

Re: regarding the column distinct feature

Gysbert_Wassenaar — Wed, 09 Mar 2016 17:25:18 GMT

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;

Re: regarding the column distinct feature

Thu, 10 Mar 2016 05:59:50 GMT

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