topic Re: Missing value in QlikView

Missing value

Wed, 01 Oct 2014 07:50:33 GMT

We use an expression to check whether a particular or multiple reports have been updated in a given time interval. We have created a cyclic group with the Day, Week and Month dimensions. The expression below works properly when we select multiple reports and displays the total number of reports updated in the given time interval. However, there's a problem when only selecting one report that hasn't been updated at all, at a given day. Then that day is omitted from the chart and when calculating weekly percentage updated reports the day without updates is omitted.

=SUM(aggr(COUNT({$<Year = {"$(#=Max(Year))"},WeekDay -= {'sat', 'sun'}>}DISTINCT QVD_Id),Month,LoadDay))/(COUNT({$<WeekDay -= {'sat', 'sun}, Time=,Day=>} Month)*GetSelectedCount(QVD_Id))

For example, as you see in the image below, when we select one report with the following time intervals, it does not show a value of zero for "5" - which is a Friday. It shows zero for "4" and that is because the report was updated after 5am but on Friday the 5th there was no update. We want the chart to show a value of zero for Friday as well.

Hope you can help us! Appreciate it!

Re: Missing value

rohit214 — Wed, 01 Oct 2014 07:59:27 GMT

Hi,

Just check the option show all values in presentation tab.

Regards

Rohit

Re: Missing value

Wed, 01 Oct 2014 08:07:51 GMT

Just in case, check that the value 5 exists on your data for that dimension. If it's there, check the box "show all values" from the Dimension tab on the properties of the chart:

Re: Missing value

Wed, 01 Oct 2014 10:03:54 GMT

Hi Jose,

Thanks for the suggestion however we have already checked this option. We know that 5 exists, but we are more concerned about our expression and whether it disables values like September 5th (that have null values) to appear on the chart.

Thanks again for the suggestion 😃

Re: Missing value

Wed, 01 Oct 2014 10:05:02 GMT

Thanks you but we have already checked this option. We know that 5 exists, but we are more concerned about our expression and whether it disables values like September 5th (that have null values) to appear on the chart.