Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
No, problem. Glad it worked out.
Please close the thread to avoid any further responses to the post.
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.
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.
No, problem. Glad it worked out.
Please close the thread to avoid any further responses to the post.