topic Aggr Function With IF Statement in QlikView

Aggr Function With IF Statement

dineshm030 — Mon, 19 Jul 2021 16:02:46 GMT

Hi All,

I am facing the issue while use AGGR function with IF statement. While using the IF statement FALSE condition is not showing. Am using below expression:

=Aggr(If(Max({<SCADA_DateTimeEST = {'$(=Max(SCADA_DateTimeEST))'}>}SCADA_FAULT_NUMBER) >= 0 ,[Machine Fault Condition],'No Demand'),[Machine Fault Condition])

Thanks in advance.

Regards,

Dinesh Kumar Mani.

Re: Aggr Function With IF Statement

Kushal_Chawda — Mon, 19 Jul 2021 16:06:31 GMT

@dineshm030 you need to define false condition in else part of the if statement

=Aggr(If(Max({<SCADA_DateTimeEST = {'$(=Max(SCADA_DateTimeEST))'}>}SCADA_FAULT_NUMBER) >= 0 ,[Machine Fault Condition],'Not matched'),[Machine Fault Condition])

Re: Aggr Function With IF Statement

dineshm030 — Mon, 19 Jul 2021 16:25:27 GMT

Now True condition is not working.

Re: Aggr Function With IF Statement

Kushal_Chawda — Mon, 19 Jul 2021 21:06:50 GMT

@dineshm030 without looking at your data and condition it is hard to tell where it is wrong. Please share sample data with expected output