Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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.