Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set analysis field must be empty

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

1 Solution

Accepted Solutions
Not applicable
Author

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 🙂

View solution in original post

3 Replies
Not applicable
Author

{<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.

Not applicable
Author

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 🙂
Not applicable
Author

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.