How to maintain the text color of row same in excel sheet ?

[suvechha_b]

I am using this expression as text color (click on '+' on your dimension/expression) :

=if(audit_type='Update New',rgb(200,0,0)) to get the report as sample.png.

But when I am exporting it to excel . The columns with red color is also becoming black.

Is there any way to export to excel extactly the same as it is showing in qlikview report.

[MK_QSL]

Can you load your sample file?

[suvechha_b]

PFA

[daveamz · Accepted solution]

Hi,

I presume you are using Excel 2003-2007 which has a limit of 65000 rows. Within that limit QlikView will preserve the color format but, if you export more than 65000 rows QlikView will make a csv file and open it in excel and all format (including colors and font) will be lost.

Try to export less rows than 65000.

Regards,

David

[suvechha_b]

This is happening when I am selecting nothing.

But if I select a particular product_code.Its coming fine...

[MK_QSL]

When I export your table.. got the right one as per your requirement.

Please check enclosed file.

If the rows are more than 65,000 (don't know the exact value), the table will be exported as .CSV file and you will lose your formatting of color.

Hope this helps...

[#7]

Hi Suvechha,

You can try increasing the limit using the below option:

This option can be found by navigating to Help--About Qlikview and then right click on the qlikviw icon in left hand side bottom.

[mangalsk]

Hello,

Find attachment

I have created table and when i export to excel it retain its text color.

Hope it works for you.

Regards