Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

vipin_mishra479
Contributor II

Bar chart

Hi to every one my problem in bar chart. Actualy what i represent monthly wise amount and in dec month my value is -3.16 lacs which i present in a bar chart my problem is that in dec month my graph show in positive direction but my value is showing in negative which is wrong repsesent in graph

so any buddy can help.

I have atteched the qvw file please check and reply.

7 Replies
Not applicable

Re: Bar chart

Hi,

It seems your graph is showing the value correctly since the negative bar appears on the bottom side of the graph.

To visualize this better, you can set the sort to Y value descending (check the attachment).

Hope that helps.

Regards,

-Khaled.

vipin_mishra479
Contributor II

Re: Bar chart

thanks for reply khaled

Its visualize better when short to y value in desending order but it repesent in wrong way so its not a correct.

rohit214
Contributor III

Re: Bar chart

Hi, Vipin

which way do you want??

thanks

rohit

vipin_mishra479
Contributor II

Re: Bar chart

actualy dec month value come in negetive way but graph represent in positive way which is wrong.

rohit214
Contributor III

Re: Bar chart

Hi Vipin,

That thing i know

but what khaled given you the solution its shows correct and one more thing which version you are using

thanks

rohit

vipin_mishra479
Contributor II

Re: Bar chart

actualy i am using qlikview 10 SR4

Not applicable

Re: Bar chart

Vipin,

Apparently, the numeric value for December  from your source data is just -3.5 (even if you are reading it as lacs) and not -350000.

I tried to reproduce the result by using -350000 and it works fine.

Here's the attachment for the same.

Hope that helps.

Regards,

-Khaled.