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

How to add all fields ending with OO in Caluculated Dimention


Hi Friends

I have to add lot of fields to a Pivot table which ends with 'OO'.

Can I add all to them to dimentions  at a time using any condition since its long time to identity them from the group of 200 Fields.

Thanks

Pavan

Tags (1)
4 Replies
MVP & Luminary
MVP & Luminary

Re: How to add all fields ending with OO in Caluculated Dimention

Do you mean fields or values of a field? If you're talking about field values you can try using a calculated dimension instead of the field itself: =if(right(MyField,2)='OO', 'Ends in OO', MyField)


talk is cheap, supply exceeds demand
Not applicable

Re: How to add all fields ending with OO in Caluculated Dimention

HI Gysbert,

I want to add Fields only.

Instead of adding one by one Is there any way to add all the fields which end with 'OO'.

Thanks

MVP & Luminary
MVP & Luminary

Re: How to add all fields ending with OO in Caluculated Dimention

Not automatically. You'll have to add them manually.


talk is cheap, supply exceeds demand
Not applicable

Re: How to add all fields ending with OO in Caluculated Dimention

Thanks