topic Re: Expression error in QlikView

Expression error

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

Hi,

I'm getting error when i use the below logic.Please provide the right expression.

Logic: aggr(if( Status_I_Min= null(), Interval( Status_A_Max - Status_null_Min, 'hh:mm:ss') and if(Interval( Status_A_Max - Status_I_Min, 'hh:mm:ss'),Application_Number)))

Thanks..

Re: Expression error

sunny_talwar — Mon, 27 Feb 2017 12:41:54 GMT

What are you trying to do? Can you elaborate? Provide sample?

Re: Expression error

nareshthavidishetty — Mon, 27 Feb 2017 12:52:08 GMT

Hi,

Below is the original expression.

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

Here i need to modify the expression as below.

if Status_I_Min= null() i need to 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)

Thanks..

Re: Expression error

sunny_talwar — Mon, 27 Feb 2017 12:56:26 GMT

May be this:

=Aggr(Interval(Status_A_Max - If(Len(Trim(Status_I_Min)) = 0, Status_null_Min, Status_I_Min), 'hh:mm:ss'), Application_Number)

Re: Expression error

muthukumar77 — Mon, 27 Feb 2017 13:26:11 GMT

Hi,

Try like this,

if(Len(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))