Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Doubt about one expression with set analysis

Hi everybody,

I have to do this.

SUM of "Number"

Concept = 'Concept1'

And 'Installation' has to be emtpy , i mean i don't have to have values in this field.

the two first are this

SUM({<Concept = {'Concept1'} >}Number)

But how i do the last thing?

Am i clear?

Thank you, greetings!

9 Replies
Not applicable
Author

Is this?

SUM({$<Instalattion={'*'}-{''}, Concept = {'Concept1'} >}Number

If this is correct. Now i wanna have the same but when Instalattion IS NOT empty

how i do that?

Thanks

marcus_sommer

Try something like this:

SUM({<Concept = {'Concept1'}, Instalattion -= {'*'} >} Number)

- Marcus

reshmakala
Creator III
Creator III

Does your original post mean that installation should be a null value? or you do not want to include it in the expression?

Not applicable
Author

The field 'Installation' has to be emtpy , it dont have to have vallues, null.


Not applicable
Author

It doesn't work!

Not applicable
Author

Without the - i dont have errors

reshmakala
Creator III
Creator III

Hope this helps   

Set analysis exclude null

Not applicable
Author

I didn't understand

what i have to put after the =-?

Not applicable
Author

OK the answer is THIS

Sum({$<SET THAT IS NOT NULL -= {""}>}THIS IS THE OPERATION)