Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

agaperuth
New Contributor

Cell and Text format in Exported excel file from qlik sense

Hi,

i'll just ask why is it some cell and text in exported excel file in qlik sense is bold and highlighted.

How does it happed?

What can i do to change it? Because i need the cell and text to be uniform.

Not bold and not highlighted.

*I got this excel file, in Export Data functionality of qlik sense.

sample.PNG


Thank You in advance for your response.

13 Replies
shraddha_g
Honored Contributor III

Re: Cell and Text format in Exported excel file from qlik sense

Can you share screenshot of this table from qliksense

agaperuth
New Contributor

Re: Cell and Text format in Exported excel file from qlik sense

Here's the screenshot in qlik, the columns are actually rambled.

in here, i've used Table to display the data from the database.

I didn't perform any calculation in all the columns.

Capture.PNG

shraddha_g
Honored Contributor III

Re: Cell and Text format in Exported excel file from qlik sense

I couldn't find columns from excels you attached earlier In this qliksense Table

shraddha_g
Honored Contributor III

Re: Cell and Text format in Exported excel file from qlik sense

Is it the same table you exported?

agaperuth
New Contributor

Re: Cell and Text format in Exported excel file from qlik sense

Yes that's the table that I've exported.

There are 100+ columns, some are invisible, the one that I've shared are the columns that are visible. Whenever i export data, all columns (100+ columns) are being exported.

These two columns are the one that was highlighted and bold whenever I export data.

Capture.PNG

*sorry for the confusion because in my updated file, i've changed the column name.

shraddha_g
Honored Contributor III

Re: Cell and Text format in Exported excel file from qlik sense

You are facing this issue in this particular app or in each app this is the same case?

agaperuth
New Contributor

Re: Cell and Text format in Exported excel file from qlik sense

In this app only. But I've tried to create new app with the same data, it's still the same.

kristien
New Contributor II

Re: Cell and Text format in Exported excel file from qlik sense

Hi,

I think it has to do with the formula in the Column. I had the same on a column Year:

When I had 'Dual(Year([Documentdate]),YearStart([Documentdate]))'  in the formula, the column was bold and highlighted, but when is changed the formula in '=Year([Documentdate])', no special format was used.

kkovalenko1
New Contributor

Re: Cell and Text format in Exported excel file from qlik sense

This is happening to me as well and the Columns are not formulas.  Is this still happening to you? 

Community Browser