topic Re: String comparison in QlikView

String comparison

gokulnath2592 — Mon, 23 Feb 2015 13:14:37 GMT

Hi all,

I want to compare string between two table and display result in a straight table.

for example table 1 has

Colors

Red

Blue

Green

Table 2 has same field as color

Red

Blue

Green

yellow

Here table 2 has extra data as yellow .

In a straight table i want to display yellow only.

please provide solution for this.

Thanks,

Gokul

MK_QSL — Mon, 23 Feb 2015 13:19:03 GMT

T1:

Load *, 'No' as Flag From TableName1;

T2:

Load *, 'SameColor' as Flag From TableName2 Where Exist (ColorFIeld);

Load *, 'DifferentColor' as Flag From TableName2 Where Not Exist (ColorFIeld);

Now create a List Box with below exrepsson

If(Flag = 'DifferentColor', ColorField)

Mon, 23 Feb 2015 13:26:38 GMT

Hi,

Load Colors from Table 1 to Table 2 with Color as Key.

Mapping Load

Colors as Color,

Colors

resident Table 1;

Table2:

Load *,

Applymap('A', Color, 'NA') as ColorMap

from Table2:

> In Straight Table dimension,

if(ColorMap='NA',color)

Regards,

Joshmi