Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
baltazarj
Contributor III
Contributor III

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

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.

baltazarj_0-1611825981184.png

Thanks in advance.

 

1 Solution

Accepted Solutions
MayilVahanan

Hi @baltazarj 

May be try like this, it will help you

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

Settings in expression tab:

MayilVahanan_0-1611912782326.png

 

Background color for your expression:

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

In presentation tab:

MayilVahanan_1-1611912870890.png

Final result:

MayilVahanan_2-1611912910526.png

 

Thanks & Regards,
Mayil Vahanan R

View solution in original post

4 Replies
MayilVahanan

Hi @baltazarj 

May be try like this, it will help you

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

Settings in expression tab:

MayilVahanan_0-1611912782326.png

 

Background color for your expression:

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

In presentation tab:

MayilVahanan_1-1611912870890.png

Final result:

MayilVahanan_2-1611912910526.png

 

Thanks & Regards,
Mayil Vahanan R

View solution in original post

baltazarj
Contributor III
Contributor III
Author

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

MayilVahanan_0-1612169201806.png

 

Thanks & Regards,
Mayil Vahanan R
baltazarj
Contributor III
Contributor III
Author

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.