topic Re: Qlikview Script If - Create new fields in QlikView

Qlikview Script If - Create new fields

alexandermllr — Wed, 12 Jul 2017 14:15:46 GMT

Hello,

I want to create a new field, when 2 fields have the same content.(order by Key)

Attached a example file.

I hope someone can help me

Thanks!

ahaahaaha — Wed, 12 Jul 2017 14:28:42 GMT

Hi,

May be like this

Table1:

Directory;

LOAD Key,

Start,

End,

Description,

value

FROM

CH02_20170712_160633.xls

(biff, embedded labels, table is Sheet1$);

Left Join

LOAD

Key,

End,

value,

If(Count(Key)=2, 'D', 'A') as NewField

Resident Table1

Group By Key, End, value;

Result

Regards,

Andrey

ahaahaaha — Wed, 12 Jul 2017 14:30:50 GMT

Example at attached file

alexandermllr — Wed, 12 Jul 2017 14:52:16 GMT

Thank you so much!