Qlik Community

New to Qlik Sense

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

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
timpoismans
Specialist
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:

Null issue.PNG

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
shraddha_g
Partner
Partner

From Add Ons, Uncheck Include Zero Values

View solution in original post

6 Replies
Ralf_Heukäufer
Partner
Partner

Hello Tim,

perhabs you can use something like that:

if(not isnull(Metingen), Employee)

timpoismans
Specialist
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!

shraddha_g
Partner
Partner

From Add Ons, Uncheck Include Zero Values

View solution in original post

timpoismans
Specialist
Specialist
Author

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

shraddha_g
Partner
Partner

Glad it worked!

PuriVelasco
Creator
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.

PuriVelasco_0-1605703312978.png

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

I thank any help!!