Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

Replace Minus Values in Pivot

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.

eg

-15 will need to be shown as

 

   (15)

Is this easy to achieve??

Many thanks

Tom

3 Replies
Not applicable

Re: Replace Minus Values in Pivot

Hi Tom

your expression must be

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

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

best regads

Chris

Re: Replace Minus Values in Pivot

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
Honored Contributor II

Re: Replace Minus Values in Pivot

here is an example Expression

2014-01-24_1514.png

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