Need to set different number forrmating for inline table

[Anonymous]

Hi,

I am new to QlikView. In my project, I created an inline table with Actual, Thousands and Millions value and used it for calculation in my expressions.

Now I need to set different number format(i.e) Without decimal places for Actuals and with 2 decimal places for Millions and Thousands.

How to set this number format in expressions for the inline values?

Can anyone help me with this?

[Anil_Babu_Samineni]

Then seems, You must need Mapping table with the existing and new tables by help of ApplyMap() function

[prieper]

pfa

[sunilkumarqv]

Hi Kiran,

Please try this

=If(GetselectedCount(_Factor)=0,Pick(Match(_Factor,'Millions','Thousands',Actuals')

NUM(SUM(Sales/Factor_Value), '#,##0.00;'),

NUM(SUM(Sales/Factor_Value), '#,##0.0 ;'),

NUM(SUM(Sales/Factor_Value), '#,##0;')),

NUM(SUM(Sales/Factor_Value), '#,##0;'))