Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Expression if EMPTY VALUE or Null

Hey guys,

Im reading an SQL query from and populating a table, which works fine!

Now I would like to set a where statement so to speak in an expression. so that rows onyl shows where my column: Registration isNull or has an empty value.

14 Replies
sunny_talwar

May add this in your expression:

{<Registration = {"=NullCount(Registration) > 0"}>}

or

{<Registration = {"=Len(Trim(Registration)) = 0"}>}

Kushal_Chawda

Which database it is? Oracle or Sql server?  want to restrict at back end or front end?

sunny_talwar

Alternatively create a flag in the script like this:

If(Len(Trim(Registration)) = 0, 1, 0) as Flag

and then use the flag

{<Flag = {1}>}

Not applicable
Author

SQL server

Kushal_Chawda

try

Sum({1-$<Registration ={'*'}>}Value)

Not applicable
Author

Not working 😕

Not applicable
Author

Not a sum just a if function

Kushal_Chawda

still not clear what you want to achieve it. Please elaborate.

sunny_talwar

I think creating the flag in the script will be the most easy way to do it.