Values in brackets to negative values

[#1]

How to handle the values in brackets to consider them as negative values. When I do sum of particular field it is.skipping the negative values which are represented in brackets.

[malini_qlikview]

Hi,

When a bracket is encountered, QlikView will treat it as a text field and hence those values are skipped when you sum it up. You need to mark these fields as negative values in the script,

you can try the below,

If(findoneof(Column1,'(')>=1,-Num(purgechar(Column1,'(,)')),Column1) AS Column1

there might be similar other functions you can use to arrive the same

[SergeyMak]

Hi,

You can specify format as #,##0.00;(#,##0.00) in chart properties on the Number tab

Or use Num function like Num(Your_Calc, '#,##0.00;(#,##0.00)')

Regards,

Sergey

[#4]

Thanks, Actually it is handling brackets without using above script, the problem was that i didn't see that the positive value is doubled,. It is strange that it didn't show two rows though they are matching.

E.g

-5

+2

-2

+5  ......                                                                                       +5?

10

Table shows only above values.Other +5 is hidden?

[#5]

Actually table box doesn't store duplicate values.

[SergeyMak]

Hi kishore Ch,

That would be great if you close the topic by selecting correct and helpful answers.

Thanks,

Sergey