topic Re: If Statement to define a Calculated Dimension in App Development

If Statement to define a Calculated Dimension

Krish-BI_Engineer — Wed, 09 Nov 2022 15:13:08 GMT

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.

Re: If Statement to define a Calculated Dimension

deepanshuSh — Wed, 09 Nov 2022 17:00:39 GMT

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.

Re: If Statement to define a Calculated Dimension

Krish-BI_Engineer — Thu, 10 Nov 2022 06:45:49 GMT

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.

Re: If Statement to define a Calculated Dimension

deepanshuSh — Thu, 10 Nov 2022 16:08:12 GMT

No, problem. Glad it worked out.

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