Filling missing dates

[W4ld]

Hello again,

I have a list of events. All those events have a date on witch they happened and an amount, how much happened.

There can be multiple events in one day and there can be none.

Also every event has a field, that says who caused it.

Now I want a dashboard, that gives me sum(amount) and a filter for who caused it.

I managed to do that without problems, except that days on witch nothing happened are not displayed. This can be deceiving, so I want those days to be displayed with sum(amount)=0.

So I went online and searched.

However all tries to implement some sort of calendar to solve this didn't work for me.

I got some of them to somewhat exist and I probably am one tiny step away from the solution, but I just can't succeed.

I am starting to descend into madness over here, so any help would be greatly appreciated.

All guides I found explain how to put a master calendar in your script, but not what to do with it to implement it in the data. Or I am to stupid to read them properly, witch is entirely possible 😵

[ChiragPradhan · Accepted solution]

Hi,

I have recently resolved a similar query that might help you.

https://community.qlik.com/t5/New-to-Qlik-Sense/Fixing-the-X-axis-of-a-line-chart/m-p/1599500#M14048...

You can try this expression in your chart.

 Sum(Value) + 0 * Sum({1} Value)

If it is what you are looking for, please mark it as resolved.

Thanks,

Chirag

[W4ld]

I thought I already tried something similar but apparently I didn't or I did it wrong.

Your solution works! Thanks a lot.

EDIT: In case somebody else tries to use this topic for help, I used the following master calendar: https://community.qlik.com/t5/QlikView-Scripting/Creating-A-Master-Calendar/td-p/341286

Also I further edited the given solution by using set analysis, in my case I added the italic part: {1<date={$}>}. This makes it so that the chart won't show dates I want to filter out as empty dates.