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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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