topic Edit Dimension "Contain" in QlikView

Edit Dimension "Contain"

Wed, 11 Feb 2015 15:44:40 GMT

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

maxgro — Wed, 11 Feb 2015 20:55:36 GMT

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)

robert_mika — Wed, 11 Feb 2015 22:25:03 GMT

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