topic Re: Doubt about one expression with set analysis in QlikView

Doubt about one expression with set analysis

Tue, 13 Jan 2015 19:04:35 GMT

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!

Tue, 13 Jan 2015 19:30:46 GMT

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 — Tue, 13 Jan 2015 19:34:59 GMT

Try something like this:

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

- Marcus

reshmakala — Tue, 13 Jan 2015 19:36:24 GMT

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

Tue, 13 Jan 2015 19:38:56 GMT

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

Tue, 13 Jan 2015 19:39:07 GMT

It doesn't work!

Tue, 13 Jan 2015 19:41:18 GMT

Without the - i dont have errors

reshmakala — Tue, 13 Jan 2015 19:45:39 GMT

Hope this helps

Tue, 13 Jan 2015 19:51:40 GMT

I didn't understand

what i have to put after the =-?

Tue, 13 Jan 2015 19:58:32 GMT

OK the answer is THIS

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