topic Re: Filled line chart - issues when having negative values (Qlikview) in QlikView

Filled line chart - issues when having negative values (Qlikview)

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Dear all,

I working with a line chart with positive and negative values. I was able to do it QlikSense but am having problems when doing it in QlikView (both images, QV and QS, are attached below).

As you may see, in QlikView file, line is filled from the actual value to the bottom of the graph. That's wrong!! It should be filled only from zero to the actual value.

Just a note: numeric values may change from one picture to the other one. That's not the issue!

I would really appreciate if anyone could help solve this issue. Thank you very much in advance.

Best regards,

Gonzalo

Re: Filled line chart - issues when having negative values (Qlikview)

devarasu07 — Thu, 04 Jan 2018 22:58:29 GMT

hi,

Try to set scale range line by min, max expression like below screen shot

Re: Filled line chart - issues when having negative values (Qlikview)

uacg0009 — Fri, 05 Jan 2018 08:46:01 GMT

Hi Gonzalo,

Is that what you want?

Please check the attachment.

Thanks.

Aiolos

Re: Filled line chart - issues when having negative values (Qlikview)

Anonymous — Fri, 05 Jan 2018 10:39:54 GMT

Hi Aiolos,

Yes, that's what I'm trying to achieve. Unfortunately, I am working with Personal Edition Qlikview and can't open the attached file. Please could you make a brief summary of the followed steps? It would be highly appreciated.

Thank you very much in advance.

Best regards,

Gonzalo

Re: Filled line chart - issues when having negative values (Qlikview)

uacg0009 — Mon, 08 Jan 2018 09:46:12 GMT

Hi Gonzalo,

Sorry to reply late.

I just created a line chart, and in Properties, in Style tab, in Look part choose fourth one.

Please have a try.

And questions please tell me.

Thanks

Aiolos