Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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)