How to use lower() in a set analysis

[chapil]

Hi, 

Can someone help me with this formula:

I just want to add somewhere in the formula lower([EXPLAIN]) but I don't know where  

=Only({<[EXPLAIN ]={"*fr*", '*none*'}>} [EXPLAIN ])

Thanks in advance

[BenjaminT]

Hi, 

I don't think you can modify the left hand side of the set analysis condition. In this case I would typically load another field into the data model that contains the lower case version of EXPLAIN, and use that in the set analysis.

Thanks

Ben

[chapil]

Thanks 

Yes of course, it will be a good idea but I'm an SU and I don't have any access to develop my own dim ... 

[NitinK7 · Accepted solution]

try once below exp

Lower(Aggr(Only({<[EXPLAIN ]={"*fr*", '*none*'}>} [EXPLAIN ]),[EXPLAIN ]))

or

Aggr(Only({<Lower ([EXPLAIN ] )={"*fr*", '*none*'}>} [EXPLAIN ]),[EXPLAIN ])

[BenjaminT]

Alternatively, you may be able to use an if statement with Wildmatch(), instead of set analysis,  like this:

only( if(Wildmatch([EXPLAIN], '*fr*', '*none*')>0, [EXPLAIN]))

Thanks

Ben

[chapil]

Thanks a lot, 
It works