To show all dates in chart

[agni_gold]

Hi All ,

I have a situation

I have 2 Fact tables and one calender

Now my both facts are linked with each other by 2 concatinated fields (Field1 + Date)

and one fact is linked with calender by his date field.

Now when i am making staight table with dimension as Month and Day and  2 expresions are sum of Amount from 1st fact and sum of amount of 2nd Fact.

Then it is only showing common day which is common in both fact .

But i want all the days in a month , for those value is not present it will show 0 and rest values.

[Clever_Anjos]

Unchecking "Supress Zero-Values" should be enough

[agni_gold]

Yes it has already been unchecked

[agni_gold]

Here is my sample application please help

[agni_gold]

Sorry forgot to attch application

[Clever_Anjos]

As I can see

• You have dates from 1-Jan-14 through 15-Jan-14
• You have ammount for all days (Fact1 + Fact2)

Am I missing something?

Would you mind sharing your DataModel?

[Clever_Anjos]

Please check if this model does what you need

Fact1:
LOAD Date1 as Date, 
     Entity1, 
     Amount1
FROM
[https://community.qlik.com/servlet/JiveServlet/download/905407-195237/Data.xlsx]
(ooxml, embedded labels, table is Fact1);


Fact2:
LOAD Date2 as Date, 
     Entity2, 
     Amount2
FROM
[https://community.qlik.com/servlet/JiveServlet/download/905407-195237/Data.xlsx]
(ooxml, embedded labels, table is Fact2);


LOAD Month, 
     Day, 
     Date
FROM
[https://community.qlik.com/servlet/JiveServlet/download/905407-195237/Data.xlsx]
(ooxml, embedded labels, table is Calender);

[agni_gold]

but i need to make join between entity also

[agni_gold]

user want entity filter he wants to see entity wise data from fact1 and fact 2

[Clever_Anjos]

Would you mind elaborating a bit more your business requirement?