Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Conditional Delete of Bolded Words within Excel File

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!                                                                                                                                                                                                                  

1 Solution

Accepted Solutions
marcus_sommer
MVP & Luminary
MVP & Luminary

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

View solution in original post

3 Replies
Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand
marcus_sommer
MVP & Luminary
MVP & Luminary

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

View solution in original post

Not applicable
Author

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.