Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

How to show record null values

hi all,

i have a table like this below

Employee idTraining Code
1EST01
2EST02
2
3EST02

if i select from list box "EST01" i need show only employee 1 and 2

Is it possibile?

Tyvm

Simone

5 Replies

Re: How to show record null values

What is the logic behind this? Please elaborate little more !

bestofwest
Contributor II

Re: How to show record null values

If You select EST01 You only have employee 1.

Not applicable

Re: How to show record null values

My mistake.

i have to show only idEmp 2 and 3.

jsaradhi
Valued Contributor

Re: How to show record null values

so when you select EST01, you show the values that are not corresponding to EST01?

Employee
Employee

Re: How to show record null values

If you want to show EMP 2 and 3 in a chart , SET Analysis can do this:

only( {$<[Training Code]=e([Training Code])> } [Training Code])

This will apply a filter to a chart to only show training codes in the set of codes that have NOT been selected.

Here is sample as well that works.

Community Browser