topic Re: Expression if EMPTY VALUE or Null in QlikView

Expression if EMPTY VALUE or Null

Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Expression if EMPTY VALUE or Null

sunny_talwar — Fri, 13 May 2016 11:14:59 GMT

May add this in your expression:

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

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

Re: Expression if EMPTY VALUE or Null

Kushal_Chawda — Fri, 13 May 2016 11:15:27 GMT

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

Re: Expression if EMPTY VALUE or Null

sunny_talwar — Fri, 13 May 2016 11:16:39 GMT

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}>}

Re: Expression if EMPTY VALUE or Null

Fri, 13 May 2016 11:17:26 GMT

SQL server

Re: Expression if EMPTY VALUE or Null

Kushal_Chawda — Fri, 13 May 2016 11:18:21 GMT

try

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

Re: Expression if EMPTY VALUE or Null

Fri, 13 May 2016 11:18:32 GMT

Not working 😕

Re: Expression if EMPTY VALUE or Null

Fri, 13 May 2016 11:20:22 GMT

Not a sum just a if function

Re: Expression if EMPTY VALUE or Null

Kushal_Chawda — Fri, 13 May 2016 11:23:48 GMT

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

Re: Expression if EMPTY VALUE or Null

sunny_talwar — Fri, 13 May 2016 11:25:21 GMT

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

Re: Expression if EMPTY VALUE or Null

Fri, 13 May 2016 11:29:55 GMT

I just want to show thw rows where Registration column is either NULL or has an empty value. Whenever it has a value don't show it in the table.

Is that clear enough sorry guys 😕

Re: Expression if EMPTY VALUE or Null

Kushal_Chawda — Fri, 13 May 2016 11:34:02 GMT

try

LOAD *

FROM Table.qvd(qvd)

where isnull(Registration) or len(trim(Registration))=0;

Re: Expression if EMPTY VALUE or Null

Fri, 13 May 2016 11:42:12 GMT

Yeah this si exactly what I want to achieve. Thing is Im loading from a SQL script not a QVD. that's why I was looking to make this in an expression.

Re: Expression if EMPTY VALUE or Null

Kushal_Chawda — Fri, 13 May 2016 11:49:49 GMT

Table:

LOAD *

where isnull(Registration) or len(trim(Registration))=0;

SQL SELECT *

FROM TABLE;

Re: Expression if EMPTY VALUE or Null

Mon, 16 May 2016 12:32:25 GMT

That script is not useful for that first we have to check what type of database we are using oracle and sql server I found one

of the best sollution video hope it"s really helpful for you https://www.youtube.com/watch?v=8olMt2AOUJ8