Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Subtotals and number patterns

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

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

View solution in original post

1 Reply
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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