topic Re: How to make condition to restrict data in QlikView

How to make condition to restrict data

Anonymous — Wed, 20 Jun 2018 08:34:13 GMT

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 — Wed, 20 Jun 2018 15:31:01 GMT

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

- Marcus

Anonymous — Thu, 21 Jun 2018 05:46:44 GMT

Hi,

Thanks, it works.

Br.

Svatava