topic Re: not expected duplicate lines in QlikView

not expected duplicate lines

joris_lansdaal — Tue, 24 Oct 2017 12:00:33 GMT

Hi all,

There's a field called 'Omschrijving' and when this field contains "accrual" the Field TYPE_2 will be discounts_accrual and otherwise discounts.

I used the below logic that seems to work but gives me duplicate lines when the logic is true.

if(Len(SubField(Lower(Omschrijving),'accrual'))<Len(Omschrijving),'Discounts_accrual','Discounts') as TYPE_2.

Can anyone tell me why this is happening and wether there's a better way then using subfield?

regards Joris

tresB — Tue, 24 Oct 2017 12:09:08 GMT

May be this?

If(WildMatch(Omschrijving, '*accrual'*), 'Discounts_accrual','Discounts') as TYPE_2

its_anandrjs — Tue, 24 Oct 2017 12:11:48 GMT

Provide sample data may be it is due to Subfield that you use on the Logic due that it created two rows better to looking on sample data though.

its_anandrjs — Tue, 24 Oct 2017 12:15:32 GMT

May be this

if( WildMatch(Lower(Omschrijving),'*accrual*','accrual*','*accrual'),'Discounts_accrual','Discounts') as TYPE_2

joris_lansdaal — Tue, 24 Oct 2017 12:18:17 GMT

Thanks! Wildmatch is shorter and does not duplicate!