Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Set analysis show selection AND null values

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_IDMAKEYEARDefect
1VW2010-
2VW2011flat tyre
3Audi2009-
4Audi2010-
5Audi2010broken window
6Trabant1989flat tyre

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

1VW2010-
3Audi2009-
4Audi2010-
5Audi2010broken window

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

tia

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

try

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

1.png

View solution in original post

2 Replies
Highlighted
Specialist
Specialist

Hi Ronald,

Try this

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

Highlighted
MVP
MVP

try

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

1.png

View solution in original post