topic Re: Qualify statement without a full stop in QlikView

Qualify statement without a full stop

helen_pip — Thu, 08 Dec 2016 13:49:22 GMT

Dear Qlikview User

I am using the Qualify statement, however would like to customize the statement so that I do not get a full stop, but an underscore instead

I.e What I am getting at the moment

IP_.

I would like to get rid of the full stop just so I get

IP_

Is there any way I can customize this?

Kind Regards

Helen

Re: Qualify statement without a full stop

adamdavi3s — Fri, 09 Dec 2016 07:32:54 GMT

Hi Helen,

This cheeky little script will do that for you, I have also attached a sample file.

Kind regards

Adam

For vTable = 0 to NoOfTables() -1
   Let vTableName = TableName(vTable);
For f = 1 to NoOfFields('$(vTableName)')
    let vFieldOld = FieldName($(f),'$(vTableName)');
    let vFieldNew = Replace('$(vFieldOld)','.','');
    RENAME FIELD $(vFieldOld) to $(vFieldNew);
Next f; 
Next ;

Re: Qualify statement without a full stop

adamdavi3s — Wed, 14 Dec 2016 08:31:01 GMT

Hi Helen,

Did this do what you wanted?