topic How to Display text to graph combining with measure using Qlik Sense in QlikView

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

baltazarj — Mon, 01 Feb 2021 01:08:52 GMT

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 — Fri, 29 Jan 2021 09:37:41 GMT

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 — Mon, 01 Feb 2021 01:08:31 GMT

Hi MayilVahanan,

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

MayilVahanan — Mon, 01 Feb 2021 08:47:15 GMT

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

baltazarj — Mon, 01 Feb 2021 09:34:04 GMT

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.