Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

boxes and lists

please help

I create a list, select the list type field.

in the field there are several types (type 1, type 2, type 3).

I need to be seen in the list of type1 and type2 only.

Снимок.PNG.png

1 Solution

Accepted Solutions
rustyfishbones
Honored Contributor II

Re: boxes and lists

Create a Calculated Expression in the List Box and say

IF(typ <> 'typ 3', typ)

4 Replies
rustyfishbones
Honored Contributor II

Re: boxes and lists

Create a Calculated Expression in the List Box and say

IF(typ <> 'typ 3', typ)

Re: boxes and lists

in that object instead of selecting a field select expression and write :

if(typ <> 'type1' or typ <> 'type2', '', typ)

hope it helps

rustyfishbones
Honored Contributor II

Re: boxes and lists

you can create the calculated expression by selecting Expression at the bottom of the list

2014-01-24_1249.png

quentin_bruno
Contributor

Re: boxes and lists

Hi,

In your list box settings, tab General, choose the field expression and write this expression:

=if(typ<>'typ 3', typ)

Hope this helps,

Quentin