This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion board where members can learn more about Qlik Sense App Development and Usage.
I've a "Master Calendar" table populated with all 366 single dates of 2020, in a field called "Order Date".
Then I've a "Orders Fact Table" also with an "Order Date" field, "Order ID" and other fields and a "Detail ID" field, and a "Orders Detail Dimension Table" with Detail ID field and other fields.
Data Model View show a correct relationship:
"Master Calendar" -> "Orders" (by "Order Date" key) -> "Details" (by "Detail ID" key)
Now I take the "Order Date" from master calendar and put it in a chart as dimension, and "count(Order ID)" as measure.
I want to see all dimension values and zero as measure for those dates with no orders.
What I'm having now is that only dates with at least one order are shown.
Guessing I've to use join/keep but I've red docs and done many tries without come to a solution.
Could you kindly help me?
Thanks in advance.