Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Missing value

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.

qlikview chart.PNG.png

Hope you can help us! Appreciate it!

4 Replies
rohit214
Creator III
Creator III

Hi,

Just check the option show all values in presentation tab.

Regards

Rohit

Not applicable

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:

Not applicable

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 😃

Not applicable

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.