topic Re: Set Analysis Problem, Data exclusion in QlikView

Set Analysis Problem, Data exclusion

Mon, 14 Jan 2013 19:38:11 GMT

Hello All,

I have a chart which has each expression based on column values, the same field values are used as filters also. No when i'm selectting the filters i want't all the other column values to be 0 and only show values for the excluded filters.

Filters:

Country	Group
US	A
EE	A
US	B
CA	C

The Chart structure is

	Country		Group
Client	US	EE	A	B	C
aaa	10	10	5	2	1
bbb	8	7	6	5	4
cccc	3	2	1	2	3

The expressions are as below for Groups

A= Sum({<Group= {A}>}Revenue)

B= Sum({<Group= {B}>}Revenue)

US = Sum({<Country= {US}>}Revenue)

My issue is that when i apply filter on Group A, i see values for Group B and C alos. I want to make these values to 0 and show values for Group A only.

Thanks

Re: Set Analysis Problem, Data exclusion

shree909 — Mon, 14 Jan 2013 19:44:31 GMT

i think u need to enclose the expression as

A= Sum({$<Group= {'A'}>} Revenue)

Re: Set Analysis Problem, Data exclusion

Mon, 14 Jan 2013 19:52:10 GMT

Hello shree,

Thanks, i tried this but does'nt work.this is not hiding the values for group B.

Thanks

Re: Set Analysis Problem, Data exclusion

nirav_bhimani — Tue, 15 Jan 2013 06:32:21 GMT

Using this it will show only those expression which are selected in filter.

try this.

Use This expression in Conditional

=SubStringCount(Concat(Group,'|'),'A')

And In Definition your normal expression like: Sum({<Group= {A}>}Revenue)

Similarly for other expressions as well.

Hope this will help you.

Regards,

Nirav Bhimani

Re: Set Analysis Problem, Data exclusion

Tue, 15 Jan 2013 06:40:21 GMT

Hi,

Set analysis will not allow to selections, it will display standard value based on expression..

Use if condition instead of Setanalysis..

(group='A',sum(Revenue

))

here it will give '0' when you make selections..

Hope it helps...

//chandra

Re: Set Analysis Problem, Data exclusion

Tue, 15 Jan 2013 12:30:23 GMT

Thanks all .

This is what used:

if(GetSelectedCount(Group)= 0,Sum({<Group={'A'}>}Revenue),

if(GetSelectedCount(Group)= 1 and GetFieldselections(Group) ='A',Sum({<Group={'A'}>}Revenue),0))

Thanks

Re: Set Analysis Problem, Data exclusion

fosuzuki — Tue, 15 Jan 2013 21:17:24 GMT

Hi,

I think that this will work and has better performance:

A= Sum({<Group*= {A}>}Revenue)

B= Sum({<Group*= {B}>}Revenue)

US = Sum({<Country*= {US}>}Revenue)

The idea is to use the *= operator in the set analysis.