topic Issues with String format in QlikView

Issues with String format

Wed, 31 Oct 2012 13:10:55 GMT

Is it possible to change the letter case to Upper for some part of the string.

Ex. 'aaa-Chennai and bb-India' this needs to converted 'AAA-Chennai AND BB-India'

Re: Issues with String format

jagan — Wed, 31 Oct 2012 13:47:03 GMT

Hi,

Try like this

=Upper(Left('Hello world', 5)) & Right('Hello World', 6)

Regards,

Jagan.

Re: Issues with String format

Tue, 06 Nov 2012 15:37:10 GMT

Let me explain my requirement clearly...

Filter values and the scenario name will be given in an excel file. And I need to apply those filter for each scnario.

First I'll load the whole data into a qvd file. Then I need to apply the filters for each scenario on that qvd and will load it in a table. So whenever the users select the scenario the values will be filtered out. (Just to avoid selecting the values manually for each scnario during the analysis)

Now the Filter conditions are in the following format

DBTableName.DBFieldName1 like 'abc%' or DBTableName.DBFieldName2 like 'de%'

This filter condition can contain any number of fields.

As I need to apply this formula on top the qvd, I cannot use 'like' function and the above string needs to be converted into

wildmatch(DBTableName.DBFieldName1,'abc*') or wildmatch(DBTableName.DBFieldName2,'de*')

Re: Issues with String format

Wed, 07 Nov 2012 14:42:08 GMT

Got the solution

='wildmatch('&replace(replace(replace(formula,'OR', ') OR wildmatch('),'like',','),'%','*')&')'