topic Re: Candlestick chart in QlikView

Candlestick chart

Oleg_Troyansky — Fri, 12 Oct 2012 15:14:59 GMT

Hi folks!

Does anyone have an example of a nice looking Candlestick chart? I made one, using a Combo chart and a combination of bars and symbols, but it only looks decent when many bars are available. As soon as the user selects a single item, the bar automatically becomes too wide, and the whole picture gets really ugly...

Any good ideas are appreciated.

If anyone knows of a good extension that can be used for a Candlstick, please let me know.

Appreciate your feedback,

Oleg Troyansky

Re: Candlestick chart

Gysbert_Wassenaar — Fri, 12 Oct 2012 16:10:34 GMT

Can't you abuse the boxplot wizard to that purpose?

Re: Candlestick chart

Oleg_Troyansky — Fri, 12 Oct 2012 17:15:52 GMT

I tried the Box plot... Doesn't look too nice either. The blocks also become too wide with just a few available values.

Thanks fo the suggestion though!

Re: Candlestick chart

Anonymous — Fri, 12 Oct 2012 17:50:16 GMT

Oleg,

Before the boxplot was avaialble (or it was and I didn't know yet), I used line chart with the conditional line style. The attribute expression defined the thikness of the line between two variables:

if(SAT>=vLowIncomeL AND SAT<vLowIncomeH, '<W10>')

Had to use quite a number of variables, but it works. And had colors, unlike the "native" QV boxplot.

Hope it helps.

Regards,

Michael

Re: Candlestick chart

Oleg_Troyansky — Fri, 12 Oct 2012 18:14:25 GMT

Thanks Michael!

This is an interesting idea... worth exploring...

Re: Candlestick chart

whiteline — Fri, 12 Oct 2012 19:22:11 GMT

Hi.

I've also used something like this to display ranges, max/min and distribution approximation.

The line style is also useful '<W1><S2>'

The only lack of fractional line width and aliasing makes sad...