topic Re: Conditional Delete of Bolded Words within Excel File in QlikView

Conditional Delete of Bolded Words within Excel File

Wed, 17 Dec 2014 01:10:11 GMT

Dear all,

I have benefited a lot from reading the discussions within this community.

I am loading a table into my app using Conditional Delete.

However, there are rows in which regions(highlighted in bold) are included in the table.

I would like to remove the bolded entries.

Rather than manually deleting them one by one, are there any methods to specifically delete bolded characters from the table using conditional delete?

Thanks!

Re: Conditional Delete of Bolded Words within Excel File

Gysbert_Wassenaar — Wed, 17 Dec 2014 10:23:23 GMT

The File Wizard cannot use excels text formatting to filter data. You will have to add real data to the excel file instead of formatting to mark the records that should be filtered out.

Re: Conditional Delete of Bolded Words within Excel File

marcus_sommer — Wed, 17 Dec 2014 11:16:44 GMT

You will need an additionally column in your excel which returned something like 'IsBold' or 'NotBold'. Have a look here how it could be done:

http://www.extendoffice.com/documents/excel/913-excel-filter-bold-cells.html

- Marcus

Re: Conditional Delete of Bolded Words within Excel File

Fri, 19 Dec 2014 08:31:29 GMT

Thanks for the reply.

It was useful.

I had hope to automate the process within QlikView for future file updates, so that future users do not have to manually modify the new excel files.

Seems that I have no choice but to modify the file.