topic Re: Bar chart in QlikView

Bar chart

vipin_mishra479 — Fri, 11 Jan 2013 09:16:52 GMT

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.

Re: Bar chart

Fri, 11 Jan 2013 09:59:06 GMT

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.

Re: Bar chart

vipin_mishra479 — Fri, 11 Jan 2013 10:06:54 GMT

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.

Re: Bar chart

rohit214 — Fri, 11 Jan 2013 10:20:49 GMT

Hi, Vipin

which way do you want??

thanks

rohit

Re: Bar chart

vipin_mishra479 — Fri, 11 Jan 2013 10:23:26 GMT

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

Re: Bar chart

rohit214 — Fri, 11 Jan 2013 11:14:55 GMT

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

Re: Bar chart

vipin_mishra479 — Fri, 11 Jan 2013 11:17:23 GMT

actualy i am using qlikview 10 SR4

Re: Bar chart

Fri, 11 Jan 2013 12:44:29 GMT

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.