Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ritvik4BI
Partner
Partner

Storing distinct records of a particular fieldname in a variable

Hi All,

I have a table which has a field called TagName. This particular field has several records. example alpha, beta and gamma they are repeating. i.e not distinct.  So I want a variable in the script editor storing all distinct records of TagName column.

 

final variable should look like this:

vTagName = 'alpha','beta','gamma'

Is this possible? If so HOW?

Thanks.

1 Solution

Accepted Solutions
PrashantSangle

Test:
Load * Inline[
ID
1
2
3
1
];

NoConcatenate
eval_distinct:
Load Concat(DISTINCT ID,',') as all_ID
Resident Test;

Let vAll_ID=peek('all_ID');

drop table eval_distinct;

 

Regards,

Prashant Sangle

Great dreamer's dreams never fulfilled, they are always transcended.

View solution in original post

1 Reply
PrashantSangle

Test:
Load * Inline[
ID
1
2
3
1
];

NoConcatenate
eval_distinct:
Load Concat(DISTINCT ID,',') as all_ID
Resident Test;

Let vAll_ID=peek('all_ID');

drop table eval_distinct;

 

Regards,

Prashant Sangle

Great dreamer's dreams never fulfilled, they are always transcended.

View solution in original post