Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

s_santalucia
Contributor

Combine charts - value 0

Hello everybody,

I have this problem:

in the combine chart, I wouldn't like to see the line from "nov" to  "dic", because I have no value for "dic" month.

For example:

Image 3.png

I hope in your answer,

thanks.

Stefania

Tags (1)
1 Solution

Accepted Solutions
justinphamvn
Contributor II

Re: Combine charts - value 0

Hi Stefania,

I think you should use If condition.

Example : If (Have a value, then Measure)

Better if you show me samples data and describe "how to no value" is mean


Regards,

Justin.

9 Replies
lironbaram
Honored Contributor II

Re: Combine charts - value 0

hi

did you try to uncheck the "include zero values" in the chart properties

Untitled.png

Chanty4u
Esteemed Contributor III

Re: Combine charts - value 0

in dimension tab  un check include null values.

Chanty4u
Esteemed Contributor III

Re: Combine charts - value 0

herenul dim.PNG

s_santalucia
Contributor

Re: Combine charts - value 0

hi Chanty 4u

I Have been proved but does not work.


this solution is valid only for the linear graph.

s_santalucia
Contributor

Re: Combine charts - value 0

hi Lirom

does not work!!!!

luismadriz
Valued Contributor

Re: Combine charts - value 0

Hi, I think you may need to apply a Limitation to get only values > 0.

Cheers,

Luis

s_santalucia
Contributor

Re: Combine charts - value 0

Hi Luis

thanks for your answer, but if follow your suggestion , in my chart last month (dic) disappeared.

Please, can you explain with an example?

N.B In same fields of dimention ("dic") there are values.  

justinphamvn
Contributor II

Re: Combine charts - value 0

Hi Stefania,

I think you should use If condition.

Example : If (Have a value, then Measure)

Better if you show me samples data and describe "how to no value" is mean


Regards,

Justin.

s_santalucia
Contributor

Re: Combine charts - value 0

Hi Justin

it's the right answer


thanks!!!

Community Browser