Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Can you share screenshot of this table from qliksense
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.
I couldn't find columns from excels you attached earlier In this qliksense Table
Is it the same table you exported?
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.
You are facing this issue in this particular app or in each app this is the same case?
In this app only. But I've tried to create new app with the same data, it's still the same.
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.
This is happening to me as well and the Columns are not formulas. Is this still happening to you?