topic Re: bar chart in QlikView

bar chart

Mon, 10 Sep 2012 08:48:39 GMT

Hi all,

I have a question in bar chart,in my bar chart i taken a month is a dimension(x-axis) with 2 expressions(2 bars).1st expresion(1 bar) is sum(value) for max(year).2nd expresion(2nd bar) is sum(value) for max(year)-1.please find the attacment.

The bar cahrt showing correctly, but i want to eliminate the prev year bars where the month values is null in current year.i wnat to show the bar chart like this

If again the values will be uploaded in sept month and so on the prev year bars of months will appear.

Can anyone have solution for this.please help me.

regards,

baru

Re: bar chart

whiteline — Mon, 10 Sep 2012 08:57:24 GMT

Use this as dimension:

=aggr(if(sum({$<year ={$(=Max(year))}>}value)<>0, month), month)

Re: bar chart

Mon, 10 Sep 2012 09:18:28 GMT

Hi whiteline,

Thanks for the solution,it is showing correctly.

I have 1 more question,how can we represent legend(2011 Budget,2011 Actual) like in the following image,

regards,

baru

Re: bar chart

whiteline — Mon, 10 Sep 2012 09:26:56 GMT

Sorry, can't see the image.

Append it as an attachment.

I guess you want to parametrize expression labels like this:

=Max(year) & ' Budget'

instead of 'prev year'

and

=Max(year) & ' Actual'

instead of 'cur.year'

Re: bar chart

Mon, 10 Sep 2012 09:34:27 GMT

Hi whiteline,

no i am not asking about the legent captions.i want represent legend as horizontal position in my chart.Like..

regards,

baru

Re: bar chart

whiteline — Mon, 10 Sep 2012 11:15:22 GMT

The same problem with images.

Could you attach them as files ?

Re: bar chart

Mon, 10 Sep 2012 11:30:17 GMT

Hi Baru,

Under the axes tab, we can change our legend position through "Dimension Axis" part.

Regards,

Kabilan K.

Re: bar chart

Mon, 10 Sep 2012 12:18:15 GMT

Hi whiteline,

i am sorry for inconvenience.please see the above image with red mark.I want legend in horizontal view in chart.above one is the example.

regards,

baru

Re: bar chart

whiteline — Mon, 10 Sep 2012 12:21:12 GMT

Select this chart (click on caption).

Press and hold Ctrl+Shift (you should see red rectangles).

Move the legend rectangle with the mouse.

Re: bar chart

Mon, 10 Sep 2012 12:38:03 GMT

Can u give a clear picture?

Regards,

Kabilan

Re: bar chart

Mon, 10 Sep 2012 12:47:33 GMT

Hi,

please find the image,in the down of image the expression legend i.e.,2011 and 2012 it is showing verticallly.

i want to show this legend in horizontally.like side-by-side.thanks in advance

Re: bar chart

whiteline — Mon, 10 Sep 2012 13:07:54 GMT

You use two expressions, so I think you just can't do this.

But you can create some other object that looks similar and place it behind the chart.