Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
s_santalucia
Partner - Creator
Partner - Creator

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

1 Solution

Accepted Solutions
justinphamvn
Creator II
Creator II

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.

View solution in original post

9 Replies
lironbaram
Partner - Master III
Partner - Master III

hi

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

Untitled.png

Chanty4u
MVP
MVP

in dimension tab  un check include null values.

Chanty4u
MVP
MVP

herenul dim.PNG

s_santalucia
Partner - Creator
Partner - Creator
Author

hi Chanty 4u

I Have been proved but does not work.


this solution is valid only for the linear graph.

s_santalucia
Partner - Creator
Partner - Creator
Author

hi Lirom

does not work!!!!

luismadriz
Specialist
Specialist

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

Cheers,

Luis

s_santalucia
Partner - Creator
Partner - Creator
Author

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
Creator II
Creator II

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
Partner - Creator
Partner - Creator
Author

Hi Justin

it's the right answer


thanks!!!