Solved: Need to set different number forrmating for inline... - Qlik Community

Anonymous · ‎2017-05-16

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?

prieper · ‎2017-05-16

something is weird in your formula,

would expect to have the formula to read sum(Sales) / $(=Factor_Value).

Further the $(=) is not required.

So your formula may read

SUM(Sales / Factor_Value).

If you wish to keep the formula, you may change the inline-table to read for e.g. Millions then 1/1000000.

Formatting might be done in the settings, else you may also store the formatting assigned to the _Factor in the inline-table.

Formulas then to read

NUM(SUM(Sales/Factor_Value), _MyFormat)

Inline then may look:

Format:

LOAD * INLINE [FormatName, FormatFactor, Format

Actual, 1, "#,##0.00"

Thousand, 1000, "#,##0"];

HTH Peter

edit: format-Table inserted

View solution in original post

prieper · ‎2017-05-16

would you please share an example?

qlikview979 · ‎2017-05-16

Hi,

We can set the number format in Number tab.

would you Please share the sample app.

vinieme12 · ‎2017-05-16

please post sample app

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

Peter_Cammaert · ‎2017-05-16

Yes we can help you with this. Please post an example of your INLINE table.

Anonymous · ‎2017-05-16

Factor_Table:

LOAD * INLINE

[

Factor_Id, _Factor, Factor_Value

1, Millions, 1

2, Thousands, 1000

3, Actuals, 1000000

];

In dashboard created a list box with "Actuals, Millions, Thousands"

and using the Inline table value in my expression.

example: sum(Sales)*$(=Factor_Value)

In this expression, I need to set the number format as #,##0 when the user clicks Actuals in the list box and need to set the number format as #,##0.0 when the user clicks Millions and Thousands list box.

how to set this. I tried using If statement in the expression. but no change. can you help with this?

Anil_Babu_Samineni · ‎2017-05-16

May be this?

=If(sum(Sales)*$(=Factor_Value)/1000000000 > 1,Num(sum(Sales)*$(=Factor_Value)/1000000000,'$#,###B'), Num(sum(Sales)*$(=Factor_Value)/1000000,'$#,###M'))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

prieper · ‎2017-05-16