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

Edit Dimension "Contain"

Hello,

Please, someone knows how to edit in Dimensions the following:

I will like to name all the "Names" that contain "Blue" in the Word (for example) as " Cold". Is this posible?

Thanks a lot

Belén

2 Replies
MVP
MVP

Re: Edit Dimension "Contain"

If I understand you want to replace Names with blue (red arrow) with Cold

If yes, the calculated dimension is in the red rectangle

=if(wildmatch(Names, '*blue*'), 'Cold', Names)

1.jpg

Re: Edit Dimension "Contain"

You can do that in Load statement as well:

t1:

load

IF(wildmatch(Category, '*blue*'), 'Cold', Category)

FROM

[151654.xlsx]

(ooxml, embedded labels, table is [Sheet1]);

where Category is your column with Names

Community Browser