Is there a way that when there is no value in a specific date\s the Qlik will convert the missing value to a ZERO value (showing the date with value=zero instead of ignoring\not presenting that date at all.
This way when I have a day\s with no value the line graph will go down to zero and up again at the next date for which a value exist?
I do not wish to create the dates manually since I have many dates-hole in the database which are varied for different cases.
Let say you collect money, from different countries and in each country there are different cities and in every city there are a few bank. You collect money from each bank but sometimes (some dates) a bank does not deposit money, does not give you money that date.
Now you want to show in a table the money deposit (aggregation expression) by country, by city or by a specific bank\s.
And when I pick a specific bank, when there is no deposit in some days, I want:
A.To present the missing days in my X line (time line)