Set analysis show selection AND null values

[ronaldvanlingen]

Hi,

I have report and I want to show all records from a selection AND the null values of the selection.

So, suppose I have a list of cars and some cars have a defect. Now I want to show all cars which have no defects and those which have a flat tire.

CAR_ID	MAKE	YEAR	Defect
1	VW	2010	-
2	VW	2011	flat tyre
3	Audi	2009	-
4	Audi	2010	-
5	Audi	2010	broken window
6	Trabant	1989	flat tyre

When I select defect;broken window, I want to see next result

1	VW	2010	-
3	Audi	2009	-
4	Audi	2010	-
5	Audi	2010	broken window

How can I achieve this in Set Analysis without changing load script

tia

[vamsee]

Hi Ronald,

Try this

IF(LEN(Concat(DISTINCT {$}Defect, '|'))<>0,Concat(DISTINCT {1}Defect, '|'), '-')

[maxgro · Accepted solution]

try

only({1-$<Defect={"*"}>+$} Defect)