topic Intersection between 2 alternates states in QlikView

Intersection between 2 alternates states

Fri, 13 Jul 2012 08:07:54 GMT

Hi community,

I've got 2 alternates states based on a same dimension for a comparative analysis, it works fine. But now, I wanted to know how much values are in the two states, abd how much aren't in.

My two states are groupe_1 and group_2, so I've got these two expression : count({[groupe_unite1]} name) and count({[groupe_unite2]} name) .

So I want something like that : count({[groupe_unite1],[groupe_unite1]} name) and count({NOT IN ([groupe_unite1],[groupe_unite2])} name).

Is it possible?

Thanks for your answer,

Mickaël.

Re: Intersection between 2 alternates states

Fri, 13 Jul 2012 08:13:15 GMT

count({$<groupe_1={'groupe_unite1','groupe_unite2'}> name)

and

count({1-$<groupe_1={'groupe_unite1','groupe_unite2'}> name)

Re: Intersection between 2 alternates states

Fri, 13 Jul 2012 08:36:00 GMT

Thanks for your answer,

but this expression don't use my alternate states, expression seems wrong just after your '$<'

Re: Intersection between 2 alternates states

Fri, 13 Jul 2012 08:49:11 GMT

start from the beginning

groupe_1 and group_2 are dimensions right?

groupe_unite1 and groupe_unite2 are values? from which dimension?

Re: Intersection between 2 alternates states

Fri, 13 Jul 2012 09:32:40 GMT

Thanks, I found my error, intersection are {[groupe_unite1]*[groupe_unite2]} and not in the two states are {[groupe_unite1]/[groupe_unite2]}.

With this it works fine.