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
QlikWorld 2023, a live, in-person thrill ride. April 17 - 20, 2023, in Las Vegas! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
nicolaas
Contributor
Contributor

Adding condition to visualization formula to remove values of no interest

Hi all,

I am new to Qlik Sense and am just getting my bearings straight.  I have this visualization I'm working on and need some help.  

I'm attempting to prevent the data currently labeled as '0' from being included in the representation.  I'm trying to do this WITHOUT using the 'Include Nulls' boolean available in the visualization configuration settings.

nicolaas_0-1674663791562.png

I've been playing around with the following expression trying to find a way to skip over / not include this records in the visualization.  I was thinking a For...Next loop could work, although I don't believe I can use that statement in the 'Edit Expression' dialog I'm working in?  Any help or insight is greatly appreciated -- thank you!

If(IsNull([table10.A260/A280 % Concentration]), 0, [table10.A260/A280 % Concentration])

 

 

 

nicolaas_1-1674663860231.png

 

 

Labels (4)
2 Replies
ViloA
Employee
Employee

Are the values actually null values or 0's?

nicolaas
Contributor
Contributor
Author

The values are set to NULL in a Case statement within my SQL query.