Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Ronald,
Try this
IF(LEN(Concat(DISTINCT {$}Defect, '|'))<>0,Concat(DISTINCT {1}Defect, '|'), '-')
try
only({1-$<Defect={"*"}>+$} Defect)