topic Re: Bar graph in QlikView

Bar graph

Thu, 29 Jan 2015 12:31:53 GMT

Hi,

I have a bar graph with two dimesions Month and Group; and I have two expressions open,close.

Group consits of three fields.Month is from Jan to Dec.

Now I want a graph that shows Open and Close for each group and each month.

i.e for group1 in jan how many open and close.

Re: Bar graph

datanibbler — Thu, 29 Jan 2015 12:41:15 GMT

Hi Ramya,

so far, that all sounds very good and definitely doable in QlikView.

What exactly is your issue now?

Best regards,

DataNibbler

Re: Bar graph

Thu, 29 Jan 2015 12:55:06 GMT

Hi,

I am able to get month wise open, close. But the issue is it we can’t recognize which is opened and closed in that. I have given colors to the group fields but not to open, close.

I am sending the required graph and present graph. Check it once.

Thanks & regards,

M.Ramya

Re: Bar graph

datanibbler — Thu, 29 Jan 2015 13:19:53 GMT

Hi Ramya,

well, that (present.png) looks all right to me - you just need a legend to visualize which is which.

That should be generated automatically, I don't really know why you haven't got it.

Is that third column in the month of December wanted?

Best regards,

DataNibbler

Re: Bar graph

Thu, 29 Jan 2015 13:33:31 GMT

Hi,

Yes, the third column i.e green color bar represents the no.of open for group1 and the rest two are no.of close for group2,group3 respectively. This is the problem with the graph. You could not recognize the open and close separately.

Thanks & regards,

M.Ramya