Discussion Board for collaboration on QlikView Scripting.
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?
Go to Solution.
May be this?
If(WildMatch(Omschrijving, '*accrual'*), 'Discounts_accrual','Discounts') as TYPE_2
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.
May be this
if( WildMatch(Lower(Omschrijving),'*accrual*','accrual*','*accrual'),'Discounts_accrual','Discounts') as TYPE_2
Thanks! Wildmatch is shorter and does not duplicate!