Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

berryandcherry6
Contributor II

Show two fields concatenated in Filterpane Qliksense

Hi,

I have a script like below

LOAD `batch_meta_data_id`,

    `batch_name`,

client_id;

FROM BATCHMETADATA;

LOAD `client_id`,

    `client_name`;

FROM CLIENT;

Now i need to show batch_name with its client_name appended in Filterpane.  But selection will be same , according to batch name selection. Just i need to append client name to batch name. Without effecting its normal functionality.

Table:

Load * INLINE [

client_name ,batch_name

Biscuits,britania

Biscuits,krackzak

Chocolate,cadbaury

Chocalate,Kitkat

]


In Filterpane when i apply, batch name. Batchname should show along with clientname

Expected Output

Biscuits- britania

Biscuits- krackzak

Chocolate- cadbaury

Chocalate- Kitkat


1 Solution

Accepted Solutions
kakani87
Contributor III

Re: Show two fields concatenated in Filterpane Qliksense

Try This Script

Batch_Table:

Load * INLINE [

client_name ,batch_name

Biscuits,britania

Biscuits,krackzak

Chocolate,cadbaury

Chocalate,Kitkat

]

;

Final:

load *, batch_name&'-'&client_name as Batch_Client

Resident Batch_Table

;

DROP Table Batch_Table

;

6 Replies
kakani87
Contributor III

Re: Show two fields concatenated in Filterpane Qliksense

Can you post some sample data

berryandcherry6
Contributor II

Re: Show two fields concatenated in Filterpane Qliksense

Have updated question please check.

kakani87
Contributor III

Re: Show two fields concatenated in Filterpane Qliksense

Something like this ??

fld_concatenate.png

berryandcherry6
Contributor II

Re: Show two fields concatenated in Filterpane Qliksense

Image is too small, its not clear

kakani87
Contributor III

Re: Show two fields concatenated in Filterpane Qliksense

Try This Script

Batch_Table:

Load * INLINE [

client_name ,batch_name

Biscuits,britania

Biscuits,krackzak

Chocolate,cadbaury

Chocalate,Kitkat

]

;

Final:

load *, batch_name&'-'&client_name as Batch_Client

Resident Batch_Table

;

DROP Table Batch_Table

;

kakani87
Contributor III

Re: Show two fields concatenated in Filterpane Qliksense

when ever you find an image  in the post kindly click on that and a pop up opens showing the image

Community Browser