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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
resibois
Contributor
Contributor

Text format for an Excel Extract for a field with an if condition

Hi,

When i made an Excel Extract for a field with a field condition, this extract in Excel with Text Format, how can i change the expression to extract in a normal way?

Thank you,

 

Aurélien Résibois

Labels (2)
2 Replies
martinpohl
Partner - Master
Partner - Master

hello,

I think it's not the problem of an if-condition but from the format?

Did you set the display format from auto to number?

Regards

resibois
Contributor
Contributor
Author

Hi,

Thank you for your answer.

When i put the expression separately without the condition the format extract in Excel is not by default text.

But, what do you mean by "Did you set the display format from auto to number?"

Community Browser