Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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

4 Replies
Gysbert_Wassenaar

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
Author

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

Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
Not applicable
Author

Thanks