Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

calculated dimension if and

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

Tags (3)
4 Replies
MK_QSL
Not applicable

Re: calculated dimension if and

Try

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

Not applicable

Re: calculated dimension if and

thank you but didn´t work

MK_QSL
Not applicable

Re: calculated dimension if and

Can you provide sample data or sample apps?

richard_pearce6
Not applicable

Re: calculated dimension if and

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

Richard

QlikCentral.com