Subtotals and number patterns

Wed, 21 Nov 2012 18:29:07 GMT

I people

I have a problem with subtotals:

I have a column with positive number and negative numbers. However, I don't want to have the minus signal '-' back to negative numbers. For that, I go to the 'Number' tab and get out the minus signal from the pattern and I don't have the minus signal anymore.

The big problem is I want the minus signal if the subtotal is negative... How can I do that??

Thanks in advance.

Best regards,

TMF

Re: Subtotals and number patterns

rwunderlich — Wed, 21 Nov 2012 18:46:18 GMT

Download the QV Cookbook from

http://robwunderlich.com/downloads/

unzip it and look at the example "Alternate format for chart Total rows.".

The example shows how to use a money format in subtotals by doing the formatting in the epression:

=if(rowno()=0 or isNull(rowno())

,money(Sum(Sales),'$#,##0;($#,##0)')

,num(Sum(Sales),'#,##0')

)

-Rob

topic Subtotals and number patterns in QlikView

Subtotals and number patterns

Re: Subtotals and number patterns