# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Valued Contributor

## 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.

Kind regards,

Tim Poismans

1 Solution

Accepted Solutions
Honored Contributor III

## Re: Hiding Null values from measures

From Add Ons, Uncheck Include Zero Values

5 Replies
Contributor III

## Re: Hiding Null values from measures

Hello Tim,

perhabs you can use something like that:

if(not isnull(Metingen), Employee)

Valued Contributor

## Re: Hiding Null values from measures

Hi Ralf

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!

Honored Contributor III

## Re: Hiding Null values from measures

From Add Ons, Uncheck Include Zero Values

Valued Contributor