Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
alexvalqlik
Contributor III
Contributor III

Create field with data

Regards,

I am using the 'Climber Selection Bar' extension and in the 'Initial Selection' property (Fig.1) I need the 'Sellers', I am currently entering them as Fixed data (Fig.2), but I need to be dynamic.

The information of the Sellers is in the field 'Nomb_Representante' of the table 'KNA1_Representantes'.

I must have a variable or generate a field that has the data.

KNA1_Representantes:

LOAD

    KUNNR                     as Cod_Representante,

    NAME1                     as Nombres_Representante,

    MID(KUNNR,5,10)&' '&NAME1 as Nomb_Representante

FROM [lib://Qvds_FI/KNA1_CLI_REP.qvd](qvd)

Where KTOKD='ZREP';

Thank you.

3 Replies
Quy_Nguyen
Specialist
Specialist

Hi Alex,

Try this:

KNA1_Representantes:

LOAD

    KUNNR                     as Cod_Representante,

    NAME1                     as Nombres_Representante,

    MID(KUNNR,5,10)&' '&NAME1 as Nomb_Representante

FROM [lib://Qvds_FI/KNA1_CLI_REP.qvd](qvd)

Where KTOKD='ZREP';

Temp:

Load Concat(Nomb_Representante,'|') as MatchField

Resident KNA1_Representantes;


Let vInit = Peek('MatchField',0,Temp);

Drop Table Temp;

Then use vInit in your Climber.

Best,

Quy

alexvalqlik
Contributor III
Contributor III
Author

Thanks Quy Nguyen, it worked!

Quy_Nguyen
Specialist
Specialist

Glad it helped. If your question has been answered to your satisfaction, please mark it as correct.