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: 
ddd111rgg23
Contributor III
Contributor III

number and text format

hello 

could you please advise me i have field called project number, it contains both (number and text), as showing below:

dosaril_0-1724925732225.png

i try to use= num(project Number],, '###0') , but that only show numbers without text 

what should i add to show both 

 

thank you 

 

Labels (2)
1 Solution

Accepted Solutions
marcus_sommer

Try: alt(num([project Number], '###0'), [project Number]) 

View solution in original post

2 Replies
marcus_sommer

Try: alt(num([project Number], '###0'), [project Number]) 

ddd111rgg23
Contributor III
Contributor III
Author

thank you