Add a case to IF Query - Qlik Community

alec1982 · ‎2012-06-21

Hi

I am using the following Query

='' & Num(

Sum(sum(Sales)

)

/ if((GetFieldSelections(_BTActiveCurrency) = '$USD'), 1, $(varBTExecSummaryUsdPerGbp))

/if(GetFieldSelections(_BTUnitOfMeasure) <> 'SQF', 0.09290304, 1)

, if((GetFieldSelections(_BtMrkPrfShowMarketRentSavingsPerUom) = 1), '#,##0.##', '#,##0'))

It works fine..

Now I need to add another case:

if((GetFieldSelections(_BtMrkPrfShowMarketRentSavingsPerUom) = 1) Use Sum[FieldAA] as Expresion

Any Ideas..

Thxs,

CELAMBARASAN · ‎2012-06-21

Hi,

='' & if((GetFieldSelections(_BtMrkPrfShowMarketRentSavingsPerUom) = 1),Num(Sum([FieldAA]),'#,##0.##'),

Num(

(sum(Sales)

/ if((GetFieldSelections(_BTActiveCurrency) = '$USD'), 1, $(varBTExecSummaryUsdPerGbp))

/if(GetFieldSelections(_BTUnitOfMeasure) <> 'SQF', 0.09290304, 1))

, '#,##0'))

Celambarasan