topic Re: Comperative report - two groups using the same filter listbox in QlikView

Comperative report - two groups using the same filter listbox

Anonymous — Wed, 28 Jun 2017 06:30:12 GMT

I want to compare between two groups that have the same type.

meaning that the field Type (listbox) is a filter for both groups.

I define 2 container and each of them has different state.

But when I select Type (default state/inherit state), it’s not effect on the groups and show all options, which its wrong since I don't want to allow cooperation between different type.

Any idea?

Thanks

Ravit

Re: Comperative report - two groups using the same filter listbox

ahaahaaha — Wed, 28 Jun 2017 07:14:49 GMT

Hi Ravit,

May be will you use predefined different states (look example at attached file)?

Regards,

Andrey

Re: Comperative report - two groups using the same filter listbox

Kushal_Chawda — Wed, 28 Jun 2017 07:25:35 GMT

You need to use set analysis to have effect of filter sin other state

=sum({[State 1]<Type=$::Type>} Sales)

Re: Comperative report - two groups using the same filter listbox

Kushal_Chawda — Wed, 28 Jun 2017 07:26:23 GMT

see this

Is possible to use alternate States with set analysis

Re: Comperative report - two groups using the same filter listbox

Anonymous — Wed, 28 Jun 2017 07:32:24 GMT

Thanks but I don't think I can use it. see this picture:

I have two groups (Report A and Report B)

And I need filter on RunID by Type field (PnP, RvR,WMI...)

Re: Comperative report - two groups using the same filter listbox

Anonymous — Wed, 28 Jun 2017 07:33:41 GMT

It's not good for me, since I need one field that common for both states. see picture down

Re: Comperative report - two groups using the same filter listbox

Kushal_Chawda — Wed, 28 Jun 2017 07:43:31 GMT

I am still not clear, what exactly you want to achieve?

Re: Comperative report - two groups using the same filter listbox

Anonymous — Wed, 28 Jun 2017 08:16:56 GMT

By default, listbox 'Run#' show all RunId's.

I want that this list will show only RunID that relevant to Type.

Type is - Multi, RvR, PnP... ( the filed on the top).

And both group should compare the same type.

I want to compare 2 diffrent RunID with the same Type.

Re: Comperative report - two groups using the same filter listbox

Kushal_Chawda — Wed, 28 Jun 2017 08:53:01 GMT

in both state, use below expression in listbox of Run#

=aggr(only({[State 1]<Type=$::Type>} Run#),Run#)

=aggr(only({[State 2]<Type=$::Type>} Run#),Run#)

Re: Comperative report - two groups using the same filter listbox

Anonymous — Wed, 28 Jun 2017 08:59:03 GMT

Thank you

Re: Comperative report - two groups using the same filter listbox

Kushal_Chawda — Wed, 28 Jun 2017 09:02:12 GMT

glad to help