Number Format by Expression

[sona_sa]

Hi Team,

I have a listbox, where option is like this :  Millions and Full Value, When I will click on Millions It should be display in KPI with 2 decimals points and If I click on Full Value, It should to display with full integer value.

I tried by format - Not able to make it possible. Can we do by expression mode.

Million - 236.23

Full Value - 236000023 

What setting I am missing.

Below is my expression:

= If(GetFieldSelections(rounding)='Millions', if(GetFieldSelections(ifrsOptions)='No', Num(Sum({<sub_account={'EXPENSE_TYPE'}, sub_account_short_description=>}transfer_price)/1000000,'##.00'),
Num(Sum({<sub_account={'EXPENSE_TYPE'}, sub_account_short_description=>}transfer_price_ex_cc)/1000000,'####')),
If(GetFieldSelections(ifrsOptions)='No', Num(Sum({<sub_account={'EXPENSE_TYPE'}, sub_account_short_description=>}transfer_price),'####'), Num(Sum({<sub_account={'EXPENSE_TYPE'}, sub_account_short_description=>}transfer_price_ex_cc),'####')))

Regards,

AK

[Gysbert_Wassenaar]

See here for an example you can adapt to your needs: https://qlikviewcookbook.com/2016/05/scaling-numbers-and-dse-tips/