topic Re: Concatenating a table field and free text in QlikView

Concatenating a table field and free text

Wed, 23 Jan 2013 14:34:24 GMT

Hi All,

I have an expression where i need to concatenate a table field and a free text. Here is an example,

=if([Dim Store Attr CD] = 'OBJ_PARAM_DIAMOND', 'DIAMOND' - [Dim Store Attr Val])

Here [Dim Store Attr CD] and [Dim Store Attr Val] are fields from a table and 'OBJ_PARAM_DIAMOND' is a field value and i Just want to Concatenate the free text, 'Diamond' and a hypen '-' with the field name [Dim Store Attr Val]

Is it possible to do. I m not getting the expected result using above expression.

Regards,

Malathi

Re: Concatenating a table field and free text

Gysbert_Wassenaar — Wed, 23 Jan 2013 14:37:33 GMT

try: 'DIAMOND - ' & [Dim Store Attr Val]

Re: Concatenating a table field and free text

Wed, 23 Jan 2013 14:56:29 GMT

Hey thanks, It worked. Now another confusion,

I need to use 2 or more conditions here like below to make different combinations. Is it doable?

=if([Dim Store Attr CD] = 'OBJ_PARAM_DIAMOND' , 'DIAMOND - ' & [Dim Store Attr Val]) or if([Dim Store Attr CD] = 'OBJ_PARAM_GOLD' , 'GOLD - ' & [Dim Store Attr Val])

Regards,

Malathi

Re: Concatenating a table field and free text

Gysbert_Wassenaar — Wed, 23 Jan 2013 15:03:57 GMT

A nested if should do the trick:

=if([Dim Store Attr CD] = 'OBJ_PARAM_DIAMOND' , 'DIAMOND - ' & [Dim Store Attr Val], if([Dim Store Attr CD] = 'OBJ_PARAM_GOLD' , 'GOLD - ' & [Dim Store Attr Val]))

Re: Concatenating a table field and free text

Wed, 23 Jan 2013 15:11:34 GMT

Nested if is working for 2 conditions, but i have three conditions to check. Is it doable?

Re: Concatenating a table field and free text

Thu, 24 Jan 2013 11:32:48 GMT

Can u tell me how to incorporate third condition as my condition is not working for 3 if loops,