topic Re: Factorise a Set Analysis member in QlikView

Factorise a Set Analysis member

Tue, 23 Dec 2014 04:47:22 GMT

Hi Guys,

I'm building a set analysis like.

=Sum ({<Field1 ={'A'}, Field2={'B'}>+<Field1 ={'A'}, Field3={'C'}>}Value)

So far it works, I just need to write it in another way.... and I cannot find the proper syntax.

I'd like something like Field1 ={'A'} and ( Field2={'B'} or Field3={'C'})

Why?

Because I will be able to put them invariables...

(In my data field1 is a time condition, field2 and 3 fields in a business hierarchy),

Any Idea?

Merry Xmas.

Eva

tresB — Tue, 23 Dec 2014 05:00:26 GMT

Field1 ={'A'} and ( Field2={'B'} or Field3={'C'})

<Field1 ={'A'}>* (<Field2={'B'}> + <Field3={'C'}>)

jyothish8807 — Tue, 23 Dec 2014 05:27:03 GMT

Hi Eva,

Try this:

=sum({ <Field1 ={'A'}>* (<Field2={'B'}> + <Field3={'C'}>)}Value)

Regards