How to make condition to restrict data

[Anonymous]

Hi,

I would like to have a if condition in  like this:

IF (value is not null or value <> '') & (value1 in ('A', 'B', 'C') Then

          <[count the displayed value]>

END IF

I am fighting with differences with common SQL and programming language that use SQL and possibilities as newbie in Qlik.

The issue is to restrict data after opening app (e.g. list of data displayed in tables or displaying correct data in charts.

Thx

Svatava

[marcus_sommer]

Try it with: if(len(trim(value))>0 and match(value1, 'A', 'B', 'C'), count(AnyValue))

- Marcus

[Anonymous]

Hi,

Thanks, it works.

Br.

Svatava