topic Re: Replace Minus Values in Pivot in QlikView

Replace Minus Values in Pivot

Fri, 24 Jan 2014 13:26:11 GMT

Hi,

I have a pivot table with many dimensions. The resulting expressions for some of these dimensions will be displayed as minus values.

For certain dimensions - some of these minus values need to be displayed as a bracketed value and the text in Red.

-15 will need to be shown as

(15)

Is this easy to achieve??

Many thanks

Tom

Fri, 24 Jan 2014 13:28:17 GMT

Hi Tom

your expression must be

='(' & fabs(sum(value)) & ')'

and in proprerties set if(value <0, red()) or use visuals cues

best regads

Chris

Nicole-Smith — Fri, 24 Jan 2014 14:58:20 GMT

1. Make your dimension look like this so that it wraps it in the parentheses:

=num(Value, '###########,###;(###########,###)')

2. Put a text color expression on the dimension like this:

Example file is attached.

rustyfishbones — Fri, 24 Jan 2014 15:16:03 GMT

here is an example Expression

then using visual cues tab, you can change it to Red if it's negative