topic Re: Merge two fields in QlikView

Merge two fields

Anonymous — Thu, 29 May 2014 08:34:55 GMT

Dear Experts,

I have two separate fields called "Customer" and "Suppliers"

The table logic is if the Customer Name is blank then there will be a supplier name filled and vice versa

Now I need to create a list box or a field where I want to show Type ie.Customer,Supplier and then after the selection the data needs to be refreshed based on that.

Kindly help me

Thanks & Regards

Jeba

Re: Merge two fields

anbu1984 — Thu, 29 May 2014 08:38:20 GMT

If(IsNull(Customer),Supplier,Customer)

Re: Merge two fields

Anonymous — Thu, 29 May 2014 08:38:41 GMT

On what basis you are going to provide supplier name or Customer name even if its blank.

Can you post some sample data???

Is it a single fact table or different dimension tables??

Please elaborate..........

Regards

Nitin

Re: Merge two fields

Anonymous — Thu, 29 May 2014 08:43:10 GMT

Hi Anbu,

Thanks for the reply.

However,this is listing the names of the Customers and Suppliers,but what I want to show in the list box is only two manual fields like below

Customer

Supplier

When user select "Customer" my table has to filter only the "Customer data" and vice versa

Kindly help

Thanks & Regards

Jeba

Re: Merge two fields

anbu1984 — Thu, 29 May 2014 08:47:15 GMT

Can you attach sample app

Re: Merge two fields

Anonymous — Thu, 29 May 2014 08:48:11 GMT

Hi Nitin,

These two are separate fields in a same table

Regards

Jeba

Re: Merge two fields

ashfaq_haseeb — Thu, 29 May 2014 08:51:45 GMT

Hi,

may be like this

If(len(trim(Customer))=0,Supplier,Customer)

Regards

ASHFAQ

Re: Merge two fields

Anonymous — Thu, 29 May 2014 08:59:05 GMT

OK I got your point.....

First of all Use inline load for Customer and supplier...

Load * inline[

Field_Category

Customer

Supplier

];

Now create the list box of Field_Category at fron t end.

Now in your chart, provide Customer and Supplier bothin dimensions and provide the enable condition for both as

Customer >> if(getselectedcount(Field_Category)=1 and GetFieldSelections(Field_Category)='Customer',1,0)

Supplier >> if(getselectedcount(Field_Category)=1 and GetFieldSelections(Field_Category)='Supplier',1,0)

Hope this will help you.

If required you can post your sample qvw...

Regards

Nitin

Re: Re: Merge two fields

Anonymous — Thu, 29 May 2014 09:01:15 GMT

Hi Anbu,

Please find attached the sample data.

Thanks & Regards

Jeba

Re: Re: Re: Merge two fields

ashfaq_haseeb — Thu, 29 May 2014 09:09:54 GMT

Hi, look at the attachment.

Below code will do the work.

If(len(trim(Customer))=0,'Supplier','Customer') as Filter

Regards

ASHFAQ

Re: Re: Merge two fields

Anonymous — Thu, 29 May 2014 09:12:32 GMT

PFA