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

Cell and Text format in Exported excel file from qlik sense

Anonymous — Tue, 14 Nov 2017 06:02:05 GMT

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.

Thank You in advance for your response.

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

shraddha_g — Tue, 14 Nov 2017 09:20:59 GMT

Can you share screenshot of this table from qliksense

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

Anonymous — Tue, 14 Nov 2017 09:31:47 GMT

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.

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

shraddha_g — Tue, 14 Nov 2017 09:37:35 GMT

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

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

shraddha_g — Tue, 14 Nov 2017 09:37:52 GMT

Is it the same table you exported?

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

Anonymous — Tue, 14 Nov 2017 09:44:40 GMT

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.

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

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

shraddha_g — Tue, 14 Nov 2017 09:46:55 GMT

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

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

Anonymous — Tue, 14 Nov 2017 09:51:17 GMT

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

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

kristien — Tue, 21 Nov 2017 10:53:00 GMT

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.

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

Anonymous — Tue, 27 Mar 2018 17:34:44 GMT

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

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

kristien — Wed, 28 Mar 2018 10:37:34 GMT

Hi Kanya,

I beleive this issue is solved in newest release of Qlik Sense (nov or feb). In what Qlik Sense version do you have this problem?

Kind Regards,

Kristien

Van: Kanya Kovalenko

Verzonden: dinsdag 27 maart 2018 19:54

Aan: Kristien REYNAERT <Kristien.REYNAERT@bewan.be>

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

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

stascher — Mon, 02 Apr 2018 15:39:40 GMT

I've seen the same issue and, as far as I can tell, it tends to affect only Dimensions (not Measures) where you have a mixture of numeric values and nulls. I've also seen it affect dates/timestamps.

You will notice that the format of the "bad" column in the resulting spreadsheet is Text, while for all other "good" columns it's General.

One workaround that I've used is to wrap the specifier of the offending Dimension in num(), date(), etc. or if possible, specify it as a Measure. I'm not sure if wrapping the dimension in a function forces it to become a measure, but it seems to work.

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

Anonymous — Mon, 02 Apr 2018 20:42:45 GMT

I've tested it on the latest version and it looks like it is no longer happens. Thank you!

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

Anonymous — Tue, 03 Apr 2018 02:27:50 GMT

This works, thank you so much