topic Re: Re: Re: Process visualization over time in QlikView

Process visualization over time

mr_novice — Tue, 11 Nov 2014 07:56:05 GMT

Hello all!

I have a very simple process where items are in different status over time. I have visualised the current status and amount in a table as below. Very simple. Now, I need to show how these statuses have changed over time and I don't want to create a table for each day in history... So how do you suggest this can be displayed in the best way?

Sparklines in the "current" table? - Comparison would be difficult.

Trendline chart with amount on Y-axis, time on x-axis and status as dimension?

Any other suggestion?

Cris

Current:

Status1	Status2	Status3	Status4	Status5
200	300	50	20	10

Yesterday:

Status1	Status2	Status3	Status4	Status5
100	400	25	80	90

Re: Process visualization over time

alexandros17 — Tue, 11 Nov 2014 08:01:05 GMT

I think that line chart is the best idea ... Time and Values on axis.

Re: Process visualization over time

Anonymous — Tue, 11 Nov 2014 08:03:44 GMT

Hi,

If you want to compare status volume in two different times, I would try to work with incremental values in a bar chart with status as dimension.

Marc.

Re: Process visualization over time

mr_novice — Tue, 11 Nov 2014 09:28:21 GMT

Thank you Alessandro. Thats my best alternative right now.

Re: Process visualization over time

mr_novice — Tue, 11 Nov 2014 09:32:22 GMT

Hi Marc,

What do you mean by incremental values on a bar chart? - One bar per status and amount on the y-axis? Should I use a stacked bar chart to show the values for different time? the x-axis would be status and time? or time and status?

Sorry for all questions.

cris

Re: Re: Process visualization over time

Anonymous — Tue, 11 Nov 2014 10:29:13 GMT

Hi,

I meant something like this:

If you want to compare current and yesterday, the incremental display will be fine. Otherwise, if you need to analize the current amount, use bar chart with total amounts.

Hope it helps.

Marc.

Re: Re: Re: Process visualization over time

Anonymous — Tue, 11 Nov 2014 10:58:02 GMT

Hi,

If you need to see both amount and compare to yesterday, you can make like this:

Does it fit for you?

Marc.

Re: Re: Re: Process visualization over time

Anonymous — Tue, 11 Nov 2014 12:04:38 GMT

Hi,

Did it help? If yes please close thread by selecting correct answer.

Marc.

Re: Re: Re: Process visualization over time

mr_novice — Mon, 24 Nov 2014 14:37:17 GMT

Gracias. It did help and I forgot to close the thread.

Cris