topic Different number formats in Straight Table Expressions in QlikView

Different number formats in Straight Table Expressions

asknyldz — Wed, 25 Nov 2020 16:16:04 GMT

Hello Everyone,

I want to Different number formats in Straight Table Expressions.

For Operating Income is $, For NOI Margin is %

How can it possible?

Account	Amount
Income	6,000 $
Margin	27.8%

Regards,

Re: Different number formats in Straight Table Expressions

Arthur_Fong — Wed, 13 Nov 2019 14:21:52 GMT

Try this:

Create a straight table with Account as Dimension,

Expression:

if(Account='Income',num(sum(Amount),'#,###'),
if(Account='Margin',num(sum(Amount)/100,'##.#%')))

In chart properties > Number >Select Expression Default.

Thanks and regards,

Arthur Fong

Re: Different number formats in Straight Table Expressions

Brett_Bleess — Mon, 18 Nov 2019 18:42:56 GMT

Askin, did Arthur's suggestion work for you? If so, do not forget to return to the thread and use the Accept as Solution button on his post to give him credit for the help and to let other Community Members know it did work. If you are still working on things, leave an update on what you still need.

In these cases, attaching a sample QVW file can be helpful too.

Regards,
Brett