Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

alexvalqlik
New Contributor II

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
Contributor III

Re: Create field with data

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
New Contributor II

Re: Create field with data

Thanks Quy Nguyen, it worked!

Quy_Nguyen
Contributor III

Re: Create field with data

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

Community Browser