Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

IF statement with more than one condition (Script)

What is going wrong in the following script?

Only when Spend_time is according to the conditions A = NO, B = hour and C=Prestatie I want de value of Spend_time to be saved als Spend_Hours, else, return value zero.

  IF (A ='NO',
      
IF (B ='hour', IF(C ='Prestatie', Spend_time,
       0),0),0)     
AS Spend_hours,

1 Solution

Accepted Solutions
Highlighted

Hi

If I understood you correctly:

If(A = 'No' And B = 'hour' And C = 'Prestatie', Spend_time, 0) As Spend_hours,

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

3 Replies
Highlighted

Hi

If I understood you correctly:

If(A = 'No' And B = 'hour' And C = 'Prestatie', Spend_time, 0) As Spend_hours,

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

Highlighted
Not applicable

Hi,

Try to put all the conditions together as If( A='NO' and B='hour' and C='Prestatie', Spend_Time, 0) as Spend_Hours.


Highlighted
Not applicable

Hi,

try

if((A ='NO') AND (B ='hour') AND (C ='Prestatie'), Spend_time,'0') as Spend_hours