Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Format in Expression

Hi everyone

I have the next format in my expression this way:

1.- first declare a variable

2.- I calling that variable in my expression to get the format that I need

The problem is just when I export the information to excel from a graphic or table doesn't appear the format and the symbols that I need.

can you help

1.-

Variable.jpg

2.-

expression.jpg

this is my graphic;

grafica.jpg

when I export the information doesn't appear the symbols is different  the format

tabla.jpg

Can you help plis?

1 Reply
Not applicable
Author

Hi Omar,

using the num() function within a expresion doesn't have any effect on excel-export.

If you can't use the format settings from the number-tab of chart-properties:

text(num(.....)) will help on excel-exports as a workaround

HtH

Roland