Reduce Multiple IF Condition from Expression.

sona_sa — Sat, 16 Nov 2024 03:11:45 GMT

Hi All,

I want to remove if condition from below expression: Is it possible to reduce the below expression code.

IF(GetFieldSelections(Options1)='Millions',IF(GetFieldSelections(Options3)='No',Sum({<sub_account={'Expense'}>}cost_plus)/min(Options1), (Sum({<sub_account={'Expense'}>}cost_plus_ex_cc)/min(Options1)),
IF(GetFieldSelections(Options3)='No', Sum({<sub_account={'Expense'}>}cost_plus), Sum({<sub_account={'Expense'}>}cost_plus_ex_cc))),

IF(GetFieldSelections(Options1)='Millions', IF(GetFieldSelections(Options3) = 'No', SUM({<sub_account = {'Expense'}>}transfer_price)/min(Options1), (SUM({<sub_account = {'Expense'}>}transfer_price_ex_cc)/min(Options1)),
IF(GetFieldSelections(Options3)='No',sum({<sub_account = {'Expense'}>}transfer_price),sum({<sub_account = {'Expense'}>}transfer_price_ex_cc)))

Regards,

topic Reduce Multiple IF Condition from Expression. in QlikView

Reduce Multiple IF Condition from Expression.