Line chart, stacked area. Empty spaces

[_k0zm0_2]

Hi, experts!

I have an issue with a line chart. But before I'll put some sample data.

Data:

LOAD

     Month(makedate(year(today()),Month)) as Month

    ,Type

    ,Value

INLINE [

Month, Type, Value

1 , Type A , 1345

1 , Type C , 32

2 , Type A , 1285

3 , Type A , 1380

4 , Type A , 1208

5 , Type A , 1790

5 , Type B , 160

5 , Type C , 160

6 , Type A , 2130

6 , Type B , 32

7 , Type A , 1786

7 , Type B , 224

7 , Type C , 102

8 , Type A , 1988

8 , Type B , 736

8 , Type C , 44

9 , Type A , 2404

9 , Type B , 64

9 , Type C , 96

9 , Type D , 128

10 , Type A , 994

10 , Type B , 192

11 , Type A , 1286

11 , Type B , 32

12 , Type A , 816

12 , Type B , 384

];

With 2 dimension (Type and Month) and a measure (sum(Value)), I get this chart (stacked area) :

I want to show the percentage of each type for the total values of every month.

With this measure:

sum(Value ) / sum(  TOTAL  <Month> Value  )

This is the output (formatting the measure as %)

In May, I have these values:

Type A: 84.83 (blue)

Type B: 7.58% (green)

Type C: 7.58% (yellow)

Total: 99,99%

Is there any option that there are no blank areas in the second chart?

The same thing happens in September with the Type D and in January, with Type C

Thanks in advance

PS: I'm using Qlik Sense 3.2 SR4

[Lucke_Hallbergson]

Change Missing values under Appearance/Presentation/Missing Values to "Show as Zeros" and You will get this chart;

[_k0zm0_2]

Thanks for the answer, I hadn't seen that option.

I've selected that option and I get this output with real values:

It looks better but I'd like to fill al the empty spaces.

Thanks again

[_k0zm0_2 · Accepted solution]

Finally I was able to solve the problem: it was not for the formula, it was for the granularity of data.

In the script I had several conditions which reduced the volume of data.

[...] WHERE Alt (Value, 0)> 0

Removing those conditions the volume of data increased but thus gained granularity.

Thanks aqu for his help.

[Thiago_AS]

Hi.
I am new in Qlik Sense "World" and would you like to understand how to do this type of stacked area chart? See the attached image with the final goal (made in excel - sorry).

Thanks for all.