If Statement to define a Calculated Dimension

[Krish-BI_Engineer]

Hi Friends, Qlikview Techies :

I need to derive a Column based on multiple conditions on dates/ time columns, as shown below.

I've tried in 'Calculated Dimension' field that to be used/displayed in a Chart.

If( [Event Time] > [Estimation_End_Time],'Late', if([Event Time] < [Estimation_Start_Time],'Early',if([Estimation_Start_Time]<[Event Time] <[Estimation_End_Time],'Within Time'
))) 

the editor dialogue box says "error in the expression". But, I'm not sure of the fix/ solution.

col label name: Precison_Time

Can you please help in solving this issue.

Thanks in Advance,

KT.

[deepanshuSh · Accepted solution]

If( [Event Time] > [Estimation_End_Time],'Late', if([Event Time] < [Estimation_Start_Time],'Early',if([Estimation_Start_Time]<[Event Time] <[Estimation_End_Time],'Within Time'
))) 

The '[Estimation_Start_Time]<[Event Time] <[Estimation_End_Time],' seems incorrect to me you need to define the or, or and condition here to compare the three values simultaneously. Also, please check if all the values are in same formating and presented in same manner by putting individual values into the boxes and checking if conditions are true or not. 

[Krish-BI_Engineer]

Ok, I got the issue with the AND operator missing among the fields used, in the 3rd nested If condition. later, it worked fine. thanks @deepanshuSh for your quick response on my query.

[deepanshuSh · Accepted solution]

No, problem. Glad it worked out. 

Please close the thread to avoid any further responses to the post.