Bar graph

[#1]

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.

[datanibbler]

Hi Ramya,

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

What exactly is your issue now?

Best regards,

DataNibbler

[#3]

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

[datanibbler]

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

[#5]

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