Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

alexandermllr
New Contributor II

Qlikview Script If - Create new fields

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!

1 Solution

Accepted Solutions
ahaahaaha
Honored Contributor

Re: Qlikview Script If - Create new fields

Example at attached file

3 Replies
ahaahaaha
Honored Contributor

Re: Qlikview Script If - Create new fields

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

1.jpg

Regards,

Andrey

ahaahaaha
Honored Contributor

Re: Qlikview Script If - Create new fields

Example at attached file

alexandermllr
New Contributor II

Re: Qlikview Script If - Create new fields

Thank you so much!

Community Browser