Adding zeros to days where no value but month filter stops working?

[eronevil]

Hello,

i know that adding + SUM({1}0) to expression places zeros to null values but after that month filter doesnt filter anymore?

I have selected spesific area that i cant show. But i seleted 1.1.2018 (yearmonth) but bar chart shows 0 values to 1.2.2018 and more.

-Ville

[vinieme12 · Accepted solution]

instead of ignoring ALL filters you might want to specify exactly which filters you want to ignore as below

SUM({DATEfield=,SomeOtherfield=}0)    <<--- this will ignore specific fields

Counter to this is you can specify which filters to apply

sum({1<Month=p(Month),SomeOtherfield=p(SomeOtherfield)>}0) << this will ignore all filters except the ones listed

[eronevil]

You must be qlik god or something like that!

Thanks man!

[vinieme12]

😂 thanks for the compliment but I'm not even close

[eronevil]

I have one question.

If i have filtered data with days 1.1-7.1 i should have values in those days. But some reason get values only those days where i have data. Day 4.1 is missing from left table but is in middle table. 

Name of tables are Sum functions what i used.

How it is possible to get selection what is like this