topic Re: How to Write a Simple IF Statement in QlikView

How to Write a Simple IF Statement

Mon, 25 Apr 2011 18:03:59 GMT

I need to write a simple IF statement that says if the calculated value is negative, then display the value as 0. Otherwise complete the expression. In Excel, the if statement would look something like this:

if A>B,A-B,0

How would I create this in QlikView?

How to Write a Simple IF Statement

erichshiino — Mon, 25 Apr 2011 18:22:35 GMT

From the help:

if( condition , then , else )

The three parameters condition, then and else are all expressions. The first one, condition, is interpreted logically. The two other ones, then and else, can be of any type. They should preferably be of the same type. If condition is true, the function returns the value of the expression then. If condition is false, the function returns the value of the expression else.

Example:

if( Amount>= 0, 'OK', 'Alarm' )

In your case

=if( Amount>= 0, Amount, 0)

How to Write a Simple IF Statement

hector — Mon, 25 Apr 2011 19:01:45 GMT

Hi, to avoid the if(), you can use range functions like rangemax

Ex.

rangemax(A-B,0)

So, if A-B > 0, the result will be (A-B), else if the result is negative, the result will be 0

Rgds

How to Write a Simple IF Statement

Mon, 25 Apr 2011 21:48:58 GMT

These answers were each helpful in different situations. Thank you SO much for taking the time to point me in the right direction. I'll be bookmarking this thread for sure.

Re: How to Write a Simple IF Statement

joancasellasvega — Fri, 29 May 2020 15:02:14 GMT

Hi,

I'm trying to create the following dimension and is not working

=If(count( distinct if( INSTANCIA > 0 , [LastModified.autoCalendar.Date]))>4,'Yes','No')

any suggestion?

Thanks in advance,

Joan

Re: How to Write a Simple IF Statement

VamsiKrishna05 — Thu, 05 May 2022 12:25:10 GMT

Hi Everyone,

Need help i need to write if condition,

I want to display attribute values where the attribute name = target_skill_MI.

Can anyone help me with the exception.

where ever the target_skill_MI is there i want to replace with attribute values remaining data should not change only this target_skill_MI need to change.