I have a Dimension : Date
Expression : Count(Distinct VID)
i want to show trends , so i taken Line Chart ... i have a 5 Days Data 09 to 13 March ...
But Line chart other date are also showing ....
i have master calander created for 1 Oct to till Date . i showing all the date in dimension ..
But i have data for 09 to 13 March ... So ideally is should show 09 to 13 March Data only
....Kindly confirm me why its happening.. please don't give suggestion to select date range with set analysis..
because i am going to get another date data also... so its now feasible to do set analysis for date..
also i tried in qlikview .. where shows correctly .. only 5 days in line chart with dimension and measures
Solved! Go to Solution.
Please verify that you disabled this option (which wasn't in your original sample):
Calculation condition: Specify an expression in this text field to set a condition that needs to be fulfilled (true) for the object to be displayed. If the condition is not fulfilled, the message in the text box Displayed message is shown. The value may be entered as a calculated formula. For example: count(distinct Team)<3
A calculation condition is useful when a chart or table is very big and makes the visualization slow to respond. A calculation condition can then help so that for example an object does not show until the user has filtered the data to a more manageable level by applying selections.
Show zero values: When unselected, measures that have the value ‘0’ are not included in the presentation. If there is more than one measure value, all the measure values must have the value ‘0’ to be excluded from the presentation.
If yu have null values you can hide them using the check box in the dimension properties.
Also, if you are finding any '0' values, you can make use of the add-ons tab in the properties panel. You can curtail even the zero values from there.