Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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])
Are the values actually null values or 0's?
The values are set to NULL in a Case statement within my SQL query.