indirect set analysis

felcar2013 — Mon, 18 Feb 2013 13:30:25 GMT

i have a table in the form:

	Segment A	Segment B	Segment C	Segment D	LostCustomer (NULL)
Segment A	345	12	23	65	56
Segment B	45	678	87	76	54
Segment C	678	98	908	54	78
Segment D	90	87	98	988	90
NewCustomer (NULL)	6	7	89	87	5623

the last row and column are NULLs

i want that in my pivot chart the intersection field appear as '0'.

With this Formula i get the intersection correctly, this is only the 5623 in the table.

count({$<[Segment_1]={'NewCustomer'},[Segment_2] = {'LostCustomer'}>} DISTINCT contact_id)

But i want the table to display all segments and values and instead of the '5623' in red, a '0'. something like count distinct(If(Segment_1 = 'NewCustomer' and Segment_2 = 'LostCustomer', 0, contact_id)

My dimensions are

Segment_1 =(Segment A, Segment B, Segment C, Segment D, NewCustomer)

Segment_2 =(Segment A, Segment B, Segment C, Segment D, LostCustomer)

How would this be with indirect set analysis?

topic indirect set analysis in QlikView

indirect set analysis