topic Re: Scatter chart in QlikView

Scatter chart

syukyo_zhu — Mon, 15 Feb 2016 14:26:24 GMT

Hi,

I wanted to create a chart to show price changes over the time.

I used scatter chart. In the simple case, as shown in my first example below: point to point

I have an article, in early2015 it was $ 60, after the first change, it becomes 50 in late March, and down to 40 at the end of 2015.

But in somes cases complex, I can observe different prices for the same date as shown in my another example: point to multipoints

So how can I do? anyone have idea about it.

Thanks

Re: Scatter chart

sinanozdemir — Mon, 15 Feb 2016 14:52:30 GMT

Hi,

Can you post some sample data? It seems like you should be able to do it with a scatter chart.

Thanks

Re: Scatter chart

luciancotea — Mon, 15 Feb 2016 14:56:10 GMT

Why don't you use CandleStick chart, which is the appropriate visualization for your kind of data?

Re: Scatter chart

syukyo_zhu — Mon, 15 Feb 2016 14:59:19 GMT

Hi,

below some sample data.

Case simple

LOAD * INLINE [

Date, Article, Price, nb change

31/01/2015, A1, 59.9, 1

31/03/2015, A1, 49.9, 2

31/12/2015, A1, 34.9, 3

];

Case complexe

LOAD * INLINE [

Date, Article, Price, nb change

31/01/2015, A1, 59.9, 1

31/03/2015, A1, 49.9, 2

31/12/2015, A1, 34.9, 3

31/12/2015, A1, 54.9, 3

];

Re: Scatter chart

sinanozdemir — Mon, 15 Feb 2016 15:13:05 GMT

What if you concatenate these two tables and then pull all the distinct values? As a result of this, you will have a cleaner data model to work with:

What do you think?

Re: Scatter chart

syukyo_zhu — Mon, 15 Feb 2016 15:14:33 GMT

we have a lots of articles, i don't know werthere CandleStick chart is appropriate for us.

Do you have un sample about CandleStick chart

Re: Scatter chart

syukyo_zhu — Mon, 15 Feb 2016 15:17:07 GMT

How can you show these datas in scatter chart?

Re: Scatter chart

sinanozdemir — Mon, 15 Feb 2016 15:50:00 GMT

Yeah, showing the dates is not pretty:

Re: Scatter chart

syukyo_zhu — Mon, 15 Feb 2016 15:55:56 GMT

Thanks sinan,

But i want to show data in scratte chart non bulles chart.