topic Re: Select specific values from one field in QlikView

Select specific values from one field

KyriakosM — Thu, 25 Jan 2024 11:39:24 GMT

Hi everyone,

Do you know how can i get values from Field 1 that does not contain 0 value in Field 2.
For example I would like to select only "BBB" and "DDD" from the table below: (red color)

Field 1	Field 2
AAA	1
AAA	2
AAA	0
BBB	1
BBB	2
CCC	0
CCC	2
DDD	3

Re: Select specific values from one field

Pierrick — Thu, 25 Jan 2024 13:35:33 GMT

Hello,

Do you want to do this in the script, in the visualization (set analysis) or in a selection filter ?

Re: Select specific values from one field

Ahidhar — Mon, 29 Jan 2024 11:12:31 GMT

in script you can use

where Field 2<> '0';

and in Front End

if(Field 2<>'0',Field 2)