Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
felcar2013
Partner - Creator III
Partner - Creator III

indirect set analysis

Hi
i have a table in the form:

Segment ASegment BSegment CSegment DLostCustomer (NULL)
Segment A34512236556
Segment B45678877654
Segment C678989085478
Segment D90879898890
NewCustomer (NULL)6789875623

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?

0 Replies