topic Re: line between two point in QlikView

line between two point

amiroh81 — Thu, 11 Dec 2014 06:33:24 GMT

Hi,

when i built a line chart and some interval are missing Appears line between the last and the next interval.

Is it possible that the line does not appear between the two points when is no data?

Re: line between two point

mato32188 — Thu, 11 Dec 2014 07:14:48 GMT

Hi Amir,

if there are no data, try to format your expression backround like

if(isnull(Yourfield), RGB(your backround), RGB (your red line color) ).

Not tested yet.

Re: line between two point

amiroh81 — Thu, 11 Dec 2014 07:57:07 GMT

thanks mato32188

but its didnt work on line chart.

if i do this suggestion on table its work fine but not on line chart.

anyone else?

Re: line between two point

mato32188 — Thu, 11 Dec 2014 08:05:30 GMT

Have you unmarked all 'suppressing' checkboxes? Dimension tab, Presentation tab

Re: line between two point

amiroh81 — Thu, 11 Dec 2014 08:09:33 GMT

yes i try this option also,

It didnt help

Re: line between two point

mato32188 — Thu, 11 Dec 2014 08:23:47 GMT

If possible, share your sample...with some random numbers, but keep original dimensions.

Re: line between two point

djallelsadki — Thu, 11 Dec 2014 08:49:25 GMT

Hi,

try this on Presentation sheet of your object

D.Sadki

Re: line between two point

amiroh81 — Thu, 11 Dec 2014 09:03:29 GMT

I allredy try this but it ddint help.

Re: line between two point

amiroh81 — Thu, 11 Dec 2014 12:33:17 GMT

hi marin,

i cant to share the original example but i make somting simler

the blue line (@2) between 11/10/2014 and 17/10/2014 are null value

Re: line between two point

mato32188 — Thu, 11 Dec 2014 12:51:27 GMT

See attachement.

Re: line between two point

pljsoftware — Thu, 11 Dec 2014 12:51:55 GMT

Hi Ohev,

I found this http://community.qlik.com/message/596960#59696

I hope help you, I tried to test this solution with sum(value) but I not solve the problem.

Do you need line? Can't you use point for your in your chart?

This can be a workaround

Regards

Luca Jonathan Panetta

Re: line between two point

djallelsadki — Thu, 11 Dec 2014 12:53:05 GMT

Hi,

try the attached application,

D.Sadki

Re: line between two point

Anonymous — Thu, 11 Dec 2014 13:00:29 GMT

Hi ,

If no data for particular interval,assign value Zero to that interval.

Then line will be aligned to 0 value on chart this way user will know

real scenario.

Regards

Neetha

Re: line between two point

amiroh81 — Thu, 11 Dec 2014 14:47:16 GMT

Thanks you all

Re: line between two point

yduval75 — Thu, 11 Dec 2014 15:02:30 GMT

Why you don't use symbol instead of line ?