topic Re: IF condition not working in QlikView

IF condition not working

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

Hi ,

I have used the below if condition but it is not giving correct results.

Condition:

=if(Len(Status_I_Min)= null(),

aggr(Interval(Status_A_Max-Status_Null_Min,'hh:mm:ss'),Application_Number),

aggr(Interval(Status_A_Max-Status_I_Min,'hh:mm:ss'),Application_Number))

Scenario(Please refer below image):

Condition for Total time taken to approve application Column

if Total time taken to create application is null then show aggr(Interval(Status_A_Max-Status_Null_Min,'hh:mm:ss'),Application_Number)

else

aggr(Interval(Status_A_Max-Status_I_Min,'hh:mm:ss'),Application_Number)

But here am not able to show the results if Total time taken to create application is null.

Re: IF condition not working

hector_munoz — Fri, 03 Mar 2017 13:13:27 GMT

Hi,

Change "Len(Status_I_Min)= null()" by "Len(Status_I_Min) = 0".

Regards,

Re: IF condition not working

nareshthavidishetty — Fri, 03 Mar 2017 13:29:20 GMT

Hi,

I have tried it but no luck.

Thanks..

Re: IF condition not working

Anil_Babu_Samineni — Fri, 03 Mar 2017 13:32:31 GMT

Can you send latest expression which you tried

Can you try Simple '' or '0'

=if(Len(Status_I_Min)= '',

aggr(Interval(Status_A_Max-Status_Null_Min,'hh:mm:ss'),Application_Number),

aggr(Interval(Status_A_Max-Status_I_Min,'hh:mm:ss'),Application_Number))

Re: IF condition not working

jonathandienst — Fri, 03 Mar 2017 13:45:16 GMT

Where are you using this expression? All the fields are naked (ie not inside an aggregation function like Sum, Count, Max) and so will not return anything unless there is only one possible value where the expression is being evaluated. That's why you are getting nulls; and what purpose does the Aggr() serve?

I think the expression you need is (if Status_I_Min as an empty string or null):

Sum(Status_A_Max - Alt(Status_I_Min, Status_Null_Min))

Format this to interval using the Property | Number for the table.

If Status_I_Min is zero, then:

Sum(Status_A_Max - If(Status_I_Min <> 0, Status_I_Min, Status_Null_Min))

Re: IF condition not working

nareshthavidishetty — Fri, 03 Mar 2017 15:27:33 GMT

Hi,

We taking the time interval difference and i thin aggregation wont help us.

Thanks..

Re: IF condition not working

nareshthavidishetty — Fri, 03 Mar 2017 15:28:07 GMT

Hi,

Still its not working.

Thanks..

Re: IF condition not working

Anonymous — Mon, 06 Mar 2017 07:05:29 GMT

Hi,

Did you try:

if(isNull(Status_I_Min) or len(trim(Status_I_Min)) = 0,

aggr(Interval(Status_A_Max-Status_Null_Min,'hh:mm:ss'),Application_Number),

aggr(Interval(Status_A_Max-Status_I_Min,'hh:mm:ss'),Application_Number))