Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
ronaldvanlingen
New 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
MVP
MVP

Re: Set analysis show selection AND null values

try

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

1.png

2 Replies
vamsee
Valued Contributor

Re: Set analysis show selection AND null values

Hi Ronald,

Try this

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

MVP
MVP

Re: Set analysis show selection AND null values

try

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

1.png