Set analysis show selection AND null values

ronaldvanlingen — Thu, 12 Oct 2017 14:49:37 GMT

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

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

tia

Re: Set analysis show selection AND null values

vamsee — Thu, 12 Oct 2017 20:20:07 GMT

Hi Ronald,

Try this

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

maxgro — Thu, 12 Oct 2017 20:46:37 GMT

try

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