Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
helen_pip
Creator II
Creator II

Qualify statement without a full stop

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

2 Replies
adamdavi3s
Master
Master

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 ;

adamdavi3s
Master
Master

Hi Helen,

Did this do what you wanted?