topic Re: Separate Area Charts with two Expressions in QlikView

Separate Area Charts with two Expressions

Yevhenii_Senko — Sat, 08 Apr 2017 14:29:55 GMT

Hi,

I have two dimensions

1) Names

2) Dates

And two Expressions

1) Leftover

2) Done

TableFact:

LOAD * INLINE [

Name, Date, Leftover, Done

Name1, 01/01/2017, 100, 100

Name1, 01/03/2017, 80, 80

Name1, 01/10/2017, 50, 30

Name1, 01/12/2017, 30, 50

Name2, 01/18/2017, 150, 30

Name2, 01/20/2017, 120, 40,

Name2, 01/25/2017, 80, 0

Name3, 01/25/2017, 200, 20

Name3, 01/26/2017, 180, 30

Name3, 02/03/2017, 150, 100

Name3, 02/10/2017, 50, 20

Name3, 02/14/2017, 30, 0

];

I need two separate Areas with two expressions divided by two dimensions.

The visualization is like in the attached qvw file (it shows how should looks each Name).

- Each expression has to show separate area.

For 'Leftover' first Area and second Area is for 'Done' expression(Is it possible to create in one layer?)

- Each Name has to be in the period by dates where this Name has values.

For example 'Name1' has values in the period from 01/01/2017 till 01/12/2017

There should be one separate area with values in this period(01/01/2017 - 01/12/2017)

The same for each Name.

!Important: Not combined Area, only separate for each name.

Is it possible to create the same in QV according to requirements?

Thanks!

Re: Separate Area Charts with two Expressions

Kushal_Chawda — Sat, 08 Apr 2017 16:00:47 GMT

you can check trellis option in dimension

see the attached.

Re: Separate Area Charts with two Expressions

Yevhenii_Senko — Sat, 08 Apr 2017 16:38:58 GMT

Thank you, but it is not quite that what I need.

There should be just one x-Axis and y-Axis for both 'Names' and 'Dates' dimensions.

This dimensions have to be on the one horizontal line.

Re: Separate Area Charts with two Expressions

Kushal_Chawda — Sat, 08 Apr 2017 16:47:29 GMT

you can make it horizontal as well/ Or else can you sketch the graph you need?

Re: Separate Area Charts with two Expressions

Yevhenii_Senko — Sat, 08 Apr 2017 17:27:28 GMT

There should be just one x-Axis and y-Axis for both 'Names' and 'Dates' dimensions.

In your file we may see three x-Axis and three y-Axis.

Please look at the example image.

Dates and values is not exactly the same as in QV file.

It's just for visualization.

Thx.

Re: Separate Area Charts with two Expressions

Kushal_Chawda — Sun, 09 Apr 2017 05:53:03 GMT

something like this?

Re: Separate Area Charts with two Expressions

Yevhenii_Senko — Sun, 09 Apr 2017 16:27:40 GMT

Thank you for your time but I have to say again the most general in this issue:

There should be just one x-Axis and y-Axis for both 'Names' and 'Dates' dimensions.

We can't use "Trellis" option in this case.