topic Re: Area chart with 2 dimensions in QlikView

Area chart with 2 dimensions

linoyel — Wed, 25 Nov 2020 16:16:04 GMT

Hi, I need to create an area chart with 2 dimensions as shown in the WantedResult picture attached.

My problem is that at the end of each sprint the line is not vertical, as well as at the beginning of each sprint the area starts from the day before actual sprint start date.

If the last sprint date was 28.03 and there were 16 issues on this day, I need the area to go down vertically and not to go to the next date - 29.03 - please see ActualResult picture atached.

Is it possible to control this in QV?

Thank you.

Re: Area chart with 2 dimensions

kaushiknsolanki — Thu, 20 Apr 2017 07:38:53 GMT

Hi Linoy,

The Actual Result JPG is not opening, can you upload it again.

Regards,

Kaushik Solanki

Re: Area chart with 2 dimensions

linoyel — Thu, 20 Apr 2017 07:40:06 GMT

Uploaded it again in a smaller size

Re: Area chart with 2 dimensions

kaushiknsolanki — Thu, 20 Apr 2017 07:54:59 GMT

HI,

Can you upload a sample data set.

Regards,

Kaushik Solanki

Re: Area chart with 2 dimensions

Thu, 20 Apr 2017 09:35:30 GMT

Hi,

This is the best i could do:

I have taken the sample data as following:

Date_1	Value
1/1/2017	99
2/1/2017	100
3/1/2017	109
4/1/2017	111
5/1/2017	222
6/1/2017	333
7/1/2017	345
8/1/2017	234
9/1/2017	235
10/1/2017	236
11/1/2017	237
12/1/2017	238

Try this expression :

if((sum(Value)-Above(sum(Value)))<0,0,Value)

Regards,

Sanya Chauhan