topic Re: Re: Joining fields when it is a specific value in QlikView

Joining fields when it is a specific value

Tue, 15 Jul 2014 18:17:28 GMT

I want to join three fields together but I only want the third field to show if it is a specific value. What is the best way to do this in the script?

For example, I have three fields: Product, Location, Color. I want to combine product_value + location_value + color_value (only if it is yellow). If it is not yellow, then I only want the new field to have Product_value + Location_value.

Re: Joining fields when it is a specific value

preminqlik — Tue, 15 Jul 2014 18:37:11 GMT

if i understood

Load Product_value,Location_Value

from table1;

join

Load Product_value ,

Location_Value,

Color_value

resident table2 where Color_value='yellow';

Re: Re: Joining fields when it is a specific value

Anonymous — Tue, 15 Jul 2014 18:49:41 GMT

You can concatenate in the load script. See attached.

Re: Joining fields when it is a specific value

Tue, 15 Jul 2014 19:39:59 GMT

I still need those product and location fields so I used the below to create a new field....

if(Color='Yellow',Product & Location & Color,Product & Location) as NewField

Thank you very much for your help as it was very helpful.