topic Concat in QlikView

Concat

Wed, 12 Oct 2011 15:17:50 GMT

Hi all,

I got two text fields to be concatenated in the following way in a new field: "Esito [Att]"-"Sottoesito" [Att]".

Esito has 2 values "OK/KO" and Sottoesito has 2 values "BLOCCANTE/NON BLOCCANTE" so I will have 3 combinations

- OK-

- KO-BLOCCANTE

- KO- NON BLOCCANTE

I would then renominate them into:

- OK- = OK

- KO-BLOCCANTE= KOB

- KO-NON BLOCCANTE= KON

I have no idea how to proceed, could you help me?

Thanks

Bruno

Concat

matt_crowther — Wed, 12 Oct 2011 15:30:04 GMT

Bruno,

In the help file look at a section called 'mapping' this allows you to replace one value in a field with another, for example 'OK-' with 'OK' and so on.

To get the combined new column simply use: Estio&'-'&Sottoestio as My_New_Column; in the load script then simply apply the mapping as per the Help File.

All the best,

Matt - Visual Analytics Ltd

Concat

Wed, 12 Oct 2011 15:37:45 GMT

Thanks,

I wouldn't use crossing tables....there is anyalternative way?

Concat

matt_crowther — Wed, 12 Oct 2011 15:45:56 GMT

You could always simply use a multiple if() statement in the load script eg:

if(Estio&'-'&Sottoestio='OK-','OK',if(Estio&'-'&Sottoestio='KO-BLOCCANTE','KOB','KON'))

Hope that helps,

Matt - Visual Analytics Ltd

Concat

Wed, 12 Oct 2011 16:17:09 GMT

i wrote it in this way but is not working

If ("Esito [Att]"&'-'&"Sottoesito [Att]"='OK-','OK',if("Esito [Att]"&'-'&"Sottoesito [Att]"='KO-NONBLOCCANTE','KON','KOB')) as "AAA"

Concat

Wed, 12 Oct 2011 17:22:54 GMT

Can you try this:

left(PurgeChar(Esito [Att]"&'-'&"Sottoesito [Att],'-'),3)

Regards,

Kiran.

Concat

Thu, 13 Oct 2011 08:59:30 GMT

this is not solving the problem...could you help me? thanks

Concat

Thu, 13 Oct 2011 09:02:01 GMT

I didn't solve the problem...anyone could help me?

Thanks

Re: Concat

Thu, 13 Oct 2011 17:47:13 GMT

Can you load example application.

Regards,

Kiran.

Re: Concat

Miguel_Angel_Baeyens — Thu, 13 Oct 2011 18:00:08 GMT

Hi,

You can give a try to the following in the script, but is better off using a mapping table and a MapSubString() function:

Pick(Match("Esito [Att]"&'-'&"Sottoesito [Att]", 'OK-', 'KO-NONBLOCCANTE', 'KO-BLOCCANTE'), 'OK', 'KON', 'KOB') AS AAA,

Note both field names and values are case sensitive in QlikView, hence the condition may not be working.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica