Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

gerhardl
Contributor II

IsNull in Set Analysis

Hi,

I've been looking around at similiar posts but can't figure this out.

I have a file that is a "current snapshot" of each account, called the Account Extract (text file).

I am loading one Account Extract that is current, and one that is a month old, and I do it like this:

current_extract:

Load

[Account No],

[Club Status]

FROM

[text file];

old_extract:

LOAD

[Account No],

[Club Status] as [Club Status_OLD]

FROM

[old text file];

Now I want to create an expression in a chart that counts the accounts that have a current Club Status of ACTIVE, but that do not exist in the old table (i.e. newly opened accounts that have club membership).

I've tried using IsNull but cannot get this to work...

Regards,

Gerhard

Tags (1)
1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: IsNull in Set Analysis

try {<[Club Status]-={'*'}>} in your set analysis expression. Actually, substituting null/missing values with real selectable values is a better solution. See the NullDisplay and NullValue variables in the help file.


talk is cheap, supply exceeds demand
2 Replies
MVP & Luminary
MVP & Luminary

Re: IsNull in Set Analysis

try {<[Club Status]-={'*'}>} in your set analysis expression. Actually, substituting null/missing values with real selectable values is a better solution. See the NullDisplay and NullValue variables in the help file.


talk is cheap, supply exceeds demand
Not applicable

Re: IsNull in Set Analysis

Hi All,

I also have a question on this subject

the first part of my formula works, With the second part I'm trying to select the oppposite set and sum another column in that case.

for the second part I also tried

Sum(
{<
 
Ontvangst_Ontvangstdatum -= {'*'}
>}
Inkoopfactuurregel_Aantal
))

But that did not work either, does anyone understand what I'm doing wrong?

Sum(
{<
 
Ontvangst_Ontvangstdatum = {'*'}
>}
Ontvangstregel_Aantal_ontvangen

)
)
+
(
Sum(
{<
 
Ontvangst_Ontvangstdatum = {''}
>}
Inkoopfactuurregel_Aantal
))

Thanks for helping

Community Browser