Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
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?
Actually table box doesn't store duplicate values.
Hi kishore Ch,
That would be great if you close the topic by selecting correct and helpful answers.
Thanks,
Sergey