Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

mr_novice
Contributor II

Process visualization over time

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?

Br

Cris

Current:

Status1Status2Status3Status4Status5
200300502010

Yesterday:

Status1Status2Status3Status4Status5
100400258090
1 Solution

Accepted Solutions
marcarreras
Valued Contributor

Re: Re: Re: Process visualization over time

Hi,

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

chart.jpg

Does it fit for you?

Marc.

8 Replies

Re: Process visualization over time

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

marcarreras
Valued Contributor

Re: Process visualization over time

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.

mr_novice
Contributor II

Re: Process visualization over time

Thank you Alessandro. Thats my best alternative right now.

mr_novice
Contributor II

Re: Process visualization over time

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.

Br

cris

marcarreras
Valued Contributor

Re: Re: Process visualization over time

Hi,

I meant something like this:

chart.jpg

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.

marcarreras
Valued Contributor

Re: Re: Re: Process visualization over time

Hi,

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

chart.jpg

Does it fit for you?

Marc.

marcarreras
Valued Contributor

Re: Re: Re: Process visualization over time

Hi,

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

Marc.

mr_novice
Contributor II

Re: Re: Re: Process visualization over time

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

Br

Cris

Community Browser