topic Re: Basic IF statement in QlikView

Basic IF statement

khaycock — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I'm not sure on the best way to do this, whether it be a calculation condition or not..

I have a table box that I only want to be displayed when 'ResponseFlag = No'

I thought it would just be a basic IF statement like this: IF(ResponseFlag = 'No', 1,0) but doesn't work.

Any ideas?

Re: Basic IF statement

Anonymous — Fri, 02 Sep 2016 14:31:28 GMT

goto layout and there show conditional and just define

ResponseFlag = 'No'

Re: Basic IF statement

swuehl — Fri, 02 Sep 2016 14:32:01 GMT

If you are using this in a calculation condition, it will be evaluated in global context, i.e. it will only return an unambiguous result if all records show the same value for ResponseFlag.

In general, you need to consider using aggregation functions, though I am not sure how this should look like in your case:

Use Aggregation Functions!

Re: Basic IF statement

Anonymous — Fri, 02 Sep 2016 14:33:59 GMT

Go in

Properties > Layout. Activate the conditional option and then put your statement there.

Re: Basic IF statement

khaycock — Fri, 02 Sep 2016 15:56:56 GMT

I want the table to show regardless but just want fields to be displayed in it that have ResponseFlag ='No'.

When I put that into layout conditional it gets rid of the whole table?

Re: Basic IF statement

swuehl — Fri, 02 Sep 2016 21:22:13 GMT

The Show or Calculation condition will affect the complete chart, it is not evaluated per row.

You can use a straight table or pivot table chart with calculated dimensions or set analysis to filter the rows.

For example, try to create a straight table chart with all fields from the table box used as dimensions, then a single expression

=Count({<ResponseFlag = {No}>} ResponseFlag)

You can hide the expression column on presentation tab if you want.