Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Yevhenii_Senko
Contributor III
Contributor III

Separate Area Charts with two Expressions

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.

1.jpg

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

Thanks!

6 Replies
Kushal_Chawda

you can check trellis option in dimension

see the attached.

Yevhenii_Senko
Contributor III
Contributor III
Author

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.

Kushal_Chawda

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

Yevhenii_Senko
Contributor III
Contributor III
Author

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.

1.jpg

Thx.

Kushal_Chawda

something like this?

Yevhenii_Senko
Contributor III
Contributor III
Author

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.