Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
helen_pip
Creator III
Creator III

How to add in text to an expression

Hello

I have an expression where I want to add some text I.e 'Hello'

Can someone help me write the expression please, as the below is not working:

 

=

if(CWT_Monthly_desc.desc_2 = '01 All Cancer Two Week Waits', (sum({<CWT_Monthly_desc.desc_2 = {'01 All Cancer Two Week Waits'}>} CWT_Monthly_desc.Desc_within_time )/ sum({<CWT_Monthly_desc.desc_2 = {'01 All Cancer Two Week Waits'}>} CWT_Monthly_desc.Desc_total

)*100) & 'Hello ' &

)

Thanks

Helen

2 Replies
Gysbert_Wassenaar

remove the last &


talk is cheap, supply exceeds demand
helen_pip
Creator III
Creator III
Author

Hello

Thank you for your response

I

have now put:

 

=

if(CWT_Monthly_desc.desc_2 = '01 All Cancer Two Week Waits', (sum({<CWT_Monthly_desc.desc_2 = {'01 All Cancer Two Week Waits'}>} CWT_Monthly_desc.Desc_within_time )/ sum({<CWT_Monthly_desc.desc_2 = {'01 All Cancer Two Week Waits'}>} CWT_Monthly_desc.Desc_total

)*100) & 'Hello '

and the text does not show in my graph.  I am working with a nested if statement  and the % or "Hello" will be shown in chart on the right axis

Do you

have any further suggestions?