Skip to main content

# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Cloud Maintenance is scheduled between March 27-30. Visit Qlik Cloud Status page for more details.
cancel
Showing results for
Search instead for
Did you mean:
Specialist

## Hiding Null values from measures

Hi all

Is there a way to hide null values from a measurement?

Asking as I got the following problem:

Employees belong to profiles. Each employee has a driving score. When comparing a driver's score to the average score, selecting a profile influences this average score (Completely normal behaviour).

So I changed my formula accordingly, with the set analysis "{<Employee = , Profile = >}":

(

(

(Sum(total<Year,Month,Week>{<MessageType = {'Acceleration'}, Employee = , Profile = >}IndType)*(Max(total<Year,Month,Week>{<MessageType = {'Acceleration'}, Employee = , Profile = >}WeightFactor))/10)

+

(Sum(total<Year,Month,Week>{<MessageType = {'Deceleration'}, Employee = , Profile = >}IndType)*(Max(total<Year,Month,Week>{<MessageType = {'Deceleration'}, Employee = , Profile = >}WeightFactor))/10)

+

(Sum(total<Year,Month,Week>{<MessageType = {'Curve'}, Employee = , Profile = >}IndType)*(Max(total<Year,Month,Week>{<MessageType = {'Curve'}, Employee = , Profile = >}WeightFactor))/10)

+

(Sum(total<Year,Month,Week>{<Employee = , Profile = >}IndSpeed)*(Max(total<Year,Month,Week>{<%MessageTypeKey = {200}, Employee = , Profile = >}WeightFactor))/10)

)

/4

/ ((Sum(total<Year,Month,Week>{<Employee = , Profile = >}Distance)/1000)/50)

)

Though with my employees listed in a table, whenever I selecht an employee or a profile the following happens:

Employee S and Employee S T belong to profile 1, but the rest does not, but are shown as Null because of the set analysis.

Is there any way to hide these Null-values? Every help is welcome.

Thanks in advance.

Kind regards,

Tim Poismans

1 Solution

Accepted Solutions
Partner - Master III

From Add Ons, Uncheck Include Zero Values

6 Replies
Partner - Creator III

Hello Tim,

perhabs you can use something like that:

if(not isnull(Metingen), Employee)

Specialist
Author

Hi Ralf

I tried your suggestion, but sadly, it's not working.

I think there was an option in Qlikview where you could hide a measure when it was Null(), which would be great at this moment.

Thanks though!

Partner - Master III

From Add Ons, Uncheck Include Zero Values

Specialist
Author

Works perfectly. Didn't know it was this simple, thank you!

Partner - Master III

Glad it worked!

Creator

I have the Include Zero Values unchecked and the dimensions without null values but I still have null values how it is been in below image.

The column with null values is a measure which uses a rank function.

I thank any help!!

Tags
Community Browser