Qlik Community

Qlik Sense App Development

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

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
isaaclin
New Contributor III

How to leave the missing value as a gap in Combo Chart?

Could someone help me to figure out on remove those drop lines in a combo chart?

I tried the chart option to leave the missing value as a gap, but it didn't work.

Thank you in advance.

HelpQlik.PNG

1 Solution

Accepted Solutions
Luminary
Luminary

Re: How to leave the missing value as a gap in Combo Chart?

Maybe one of these:

Add-ons > Data handling > Include zero values (deselect)

or

IF(Measure > 0, Measure)

View solution in original post

3 Replies
Luminary
Luminary

Re: How to leave the missing value as a gap in Combo Chart?

Maybe one of these:

Add-ons > Data handling > Include zero values (deselect)

or

IF(Measure > 0, Measure)

View solution in original post

isaaclin
New Contributor III

Re: How to leave the missing value as a gap in Combo Chart?

Thank you Ivan for the quick response and the correct answer.

the option 2 works for me for my case, but I believe the option 1 could work, if I convert the null into 0 in my load script.

Thanks again.

Isaac

Luminary
Luminary

Re: How to leave the missing value as a gap in Combo Chart?

Glad it works.