Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try
=IF(Left(conta_id,2) = 92 and Len(conta_id)=4, conta_id)
thank you but didn´t work
Can you provide sample data or sample apps?
Try adding the code to your script and create a new field
Richard
QlikCentral.com