topic Re: estrazione record con campo a null in QlikView

estrazione record con campo a null

warrentk80 — Wed, 09 Mar 2016 14:12:17 GMT

Goodmorning everyone,

I need to display in a table-like graph, only the records that have the lD empty field (null) You would know someone show me how to do? I entered the dimensions that m affect expression that I use to filter records with null lD?

Thank you Andrew

Re: estrazione record con campo a null

andrespa — Wed, 09 Mar 2016 14:19:31 GMT

Hi Andrea, you could put something like this as a dimension:

=IF(IsNull(ID)=-1, ID)

Hope it helps,

Andrés

Re: estrazione record con campo a null

warrentk80 — Wed, 09 Mar 2016 14:42:41 GMT

Hello Andrea, thanks for your kind and polite response.
I tried to insert as a dimension calculated the formula that you have shown me,
but I keep all records 😞

Re: estrazione record con campo a null

andrespa — Wed, 09 Mar 2016 14:50:32 GMT

Hi Andrea, no worries. Then maybe in the script you could put something like this:

Table:

Load *

From [your_path]

WHERE isNull(ID)=-1;

And then it should give you just the ID null values

Hope it helps,

Andrés