Qlik send show all the days from month even though the values are zero / null

[loganathan]

Hi All,

I have added 'include null' and 'show zero value' but still could not get value for 5th feb as per attached in image. as per requirement i need to keep all the dates from the month. Please advise. 

TIA

[Gabbar]

Try replacing measure with  Coalesce(Measure,0).

[loganathan]

Hi Gabber,

Thanks for your quick response but unfortunately it not working. Please suggest any other way to crack it down. TIA

[Gabbar]

Try This:
Go into charts Appearance>Presentation>missing Values>show as zeroes

[loganathan]

Hi Gabbar,

No its not working still same no changes. and as well this options are only applicable for charts know. if i want this to be enabled in Pivot then no idea. 

TIA

[Or]

If there is no value for February 5th, it will not show up unless the X axis is continuous (which it does not appear to be). Either mark the X axis as continuous, or ensure there is a value for Feb. 5th (even if that value is 0/null on the Y value, you'll need the dimension value).

[loganathan]

Hi,

I dont have value for 5th feb but wanted to show as '0'. even the x axis as continuous doesnt help in this case. TIA

[Or]

In that case, you might consider making sure there is a record for the missing dates. This can be done by  loading all of the possible dates in your range (using Autogenerate), without any other fields/data attached. Here's a simplistic example:

Load Num(Dim) as Dim, Value INLINE [
Dim, Value
1, 150
2, 10
3, 200
4, 50

6, 100];

Load RecNo() as Dim Autogenerate(6);

[Gabbar]

The only reason i know that is happening is because your data might not have any datefield data having a date 5th feb.
Try creating a calendar and link datefield from your table to datefield of calendar,
in this way you calendar will have 5th of feb in the datefield and thus it will be shown on X-axis. and then one of my above methods will work.