topic Set analysis field must be empty in QlikView

Set analysis field must be empty

Wed, 02 Sep 2009 21:09:06 GMT

Hi all,

i want to create a set statement. This set statement includes the field VBAK.AUGRU

But I only want to count value if the field VBAK.AUGRU is empty.

Is this possible and how should my statement be?

{<VBAK.AUGRU=????>}

Tnx for your reply

Rey-man

Set analysis field must be empty

Wed, 02 Sep 2009 21:17:34 GMT

{<VBAK.AUGRU={}>}

You could probably also use anything that is not a valid value:

{<VBAK.AUGRU={'supercalifragilisticexpialidocious'}>}

There is a small paragraph about this in the Set Modifiers portion of the Set Analysis section. I have page 329 of Book I, but I think mine is from the 8.5 documentation.

Set analysis field must be empty

Wed, 02 Sep 2009 21:38:23 GMT

Thanks for your reply

It doens't work unfortunately. But I tested something else and

{<VBAK.AUGRU={""}>} (with the "" between the {}) it does work, so it is a little different.

the
{<VBAK.AUGRU={'supercalifragilisticexpialidocious'}>}

doesn't work neither, but I liked the idea 🙂

Set analysis field must be empty

Wed, 02 Sep 2009 22:21:12 GMT

Yeah, I just looked again and it is double quotes around supercalifragilisticexpialidocious to get it to work. In the manual, they also use {} without anything else, but that could just be an oversight.