Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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