topic Re: Bar Chart Expression Question in QlikView

Bar Chart Expression Question

Mon, 07 Apr 2014 01:50:42 GMT

I have the following data. I need an expression for a bar chart where the top of the bar for any day is the price for that day where Type=H and the bottom of the bar is the price where Type=L. You cant use where expressions so I have to find some other way. Help is much appreciated.

Date	Type	Price
3/6/2014	H	40.3
3/6/2014	L	37.2
3/7/2014	H	39.8
3/7/2014	L	36.5
3/8/2014	H	40.2
3/8/2014	L	38.2
3/9/2014	H	42.2
3/9/2014	L	40.1

Re: Bar Chart Expression Question

chiru_thota — Mon, 07 Apr 2014 02:21:35 GMT

Do you want some thing like as below or different ?

Re: Bar Chart Expression Question

Mon, 07 Apr 2014 02:25:09 GMT

close to that except for example day 3/6/2014 the bottom of the bar is at 37.2 and the top of the bar is at 40.3. these prices are daily prices for like a stock.

Re: Bar Chart Expression Question

chiru_thota — Mon, 07 Apr 2014 02:33:26 GMT

But I could not see any value as 37.4 in your list of data....How are getting 37.4 for date 3/6/2014 ?

Re: Bar Chart Expression Question

Mon, 07 Apr 2014 02:48:34 GMT

Sorry meant 37.2. For each day there is a Hi and a Low price. I am trying to build a bar chart w/ the bottom of the bar for that day at the Low price and the top of the bar at the Hi price. For day 3/6/2014 the top would be at 40.3 and the bottom at 37.2. Thanks.

Re: Bar Chart Expression Question

chiru_thota — Mon, 07 Apr 2014 02:51:33 GMT

ok...Can you add a picture of what you want exactly?

rough diagram using Paint is fine .Because my picture is showing the same ..right ?

Re: Bar Chart Expression Question

Mon, 07 Apr 2014 03:04:11 GMT

Re: Bar Chart Expression Question

Mon, 07 Apr 2014 03:17:47 GMT

In the chart properties, Axes tab did you try using static min and static max?

Suraj

Re: Bar Chart Expression Question

Mon, 07 Apr 2014 03:25:29 GMT

Or you can do a thing. write two expressions. One for sum of price for and another one for sum of price for 'H' -sum of price for 'L'. Go to style and make the sub type stacked. Then go to colors and make the first color transparency 100%.

Suraj

Re: Re: Bar Chart Expression Question

chiru_thota — Mon, 07 Apr 2014 03:32:12 GMT

Below trick may be helpful. Properties --> Colors --> give white as first color