Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Addition of computed field

Hi there

Does anyone know how to add a computed field to an existing bar chart. I.e i have an input tax bar, I plan to add an output tax bar next to the bar chart (I have data for both tables), now I want to create an additional bar called nett which is composed of Output-Input is this possible?

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Using no dimensions and three expressions, this should be possible:

=Sum(InputTax)

=Sum(OutputTax)

=column(1)-column(2)

View solution in original post

5 Replies
swuehl
MVP
MVP

Using no dimensions and three expressions, this should be possible:

=Sum(InputTax)

=Sum(OutputTax)

=column(1)-column(2)

Not applicable
Author

Hi thanks for the response, last question if you can help

I have a list of customers and I want to show various customer information in a pie chart but im getting an error stating that pie chart cannot display negative values or zeros

swuehl
MVP
MVP

Ok, what's your question then?

Not applicable
Author

I want to spilt customers (valid and non valid) on a pie chart, but I get the error "The chart is not displayed because it contains only negatives or zero values" when I created my valid and non valid measures. and tried to use the total customers as my dimension.

swuehl
MVP
MVP

If you have issues like that, you need to post the dimension and expressions used in your charts, any settings you have modified and potentially some details about your data model.

Most of the time the easiest way tpo provide these informations is attaching a small sample QVW to your post.