calculated dimension if and

[#1]

Why this works for a field in a listbox and not for a calculated dimmension in a pivot table

=if(left(conta_id,2)='92'and Len(conta_id)=4,conta_id)

thank you for your time

[MK_QSL]

Try

=IF(Left(conta_id,2) = 92 and Len(conta_id)=4, conta_id)

[#3]

thank you but didn´t work

[MK_QSL]

Can you provide sample data or sample apps?

[richard_pearce6]

Try adding the code to your script and create a new field

Richard

QlikCentral.com