How to Display text to graph combining with measure using Qlik Sense

[baltazarj]

Hi, Good day!

I was wondering if it is possible to simultaneously display Text and Measure

I want to display the text No Rating to the Graph for months with no data and display the actual measure if has data.

Thanks in advance.

[MayilVahanan · Accepted solution]

Hi @baltazarj 

May be try like this, it will help you

if(YourExpression = 0, Dual('No Data',5), yourexpression)

Settings in expression tab:

Background color for your expression:

If(yourexpression=0, white(), blue()) , instead of white, you can provide ur chart backgroundcolor.

In presentation tab:

Final result:

[baltazarj]

Hi MayilVahanan,

I forgot to tell that I am using Qlik Sense and not Qlik View.

[MayilVahanan]

HI @baltazarj 

Same expression and change the option in "Appearance" like below. Hope it helps

[baltazarj]

Hi,

It is now working with Bar Chart.

My initial issue was because I am using Combo Chart (Bar and Line).

I hope there is a work around using Combo Chart.