topic Re: Ignore selection from two fields in an if statement in QlikView

Ignore selection from two fields in an if statement

Fri, 28 Aug 2015 10:37:39 GMT

Hi,

I have an if statement that I use to change the background colour of an expression in a table.

The expression is as simple as

if(monthstart(StartDate) <= monthstart(today()) or StartDate < 30, red())

The expression works as expected, but I would like the expression to ignore a selection from two specific fields in my app as when a user makes selections on those fields, the colour expression doesn't work as expected.

Can someone please let me know if it is possible to exclude selections in an if statement and how to do it if possible?

Many thanks

Re: Ignore selection from two fields in an if statement

jonathandienst — Fri, 28 Aug 2015 11:05:14 GMT

Possibly this:

if(monthstart(Only({<Field1=, Field2=>} StartDate)) <= monthstart(today()) or Only({<Field1=, Field2=>} StartDate) < 30, red())

(change Field1, Field2 to the correct fieldnames)

Re: Ignore selection from two fields in an if statement

Fri, 28 Aug 2015 11:10:46 GMT

Fantastic Jonathan.

Many thanks