Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
gonzaloyaguesun
New Contributor III

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

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

4 Replies
devarasu07
Honored Contributor II

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

hi,

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

Capture.JPG

Partner
Partner

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

Hi Gonzalo,

Is that what you want?

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

Please check the attachment.

Thanks.

Aiolos

gonzaloyaguesun
New Contributor III

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

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

Partner
Partner

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

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