topic Re: Values in brackets to negative values in QlikView

Values in brackets to negative values

Thu, 08 Oct 2015 01:31:44 GMT

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.

Re: Values in brackets to negative values

malini_qlikview — Thu, 08 Oct 2015 10:29:55 GMT

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

Re: Values in brackets to negative values

SergeyMak — Thu, 08 Oct 2015 10:46:26 GMT

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

Re: Values in brackets to negative values

Fri, 09 Oct 2015 03:01:15 GMT

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

+5 ...... +5?

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

Re: Values in brackets to negative values

Tue, 13 Oct 2015 15:19:18 GMT

Actually table box doesn't store duplicate values.

Re: Values in brackets to negative values

SergeyMak — Wed, 11 Nov 2015 02:19:45 GMT

Hi kishore Ch,

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

Thanks,

Sergey