topic Re: Addition of computed field in QlikView

Addition of computed field

Wed, 08 Jul 2015 09:06:22 GMT

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?

Re: Addition of computed field

swuehl — Thu, 16 Jul 2015 22:09:22 GMT

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

=Sum(InputTax)

=Sum(OutputTax)

=column(1)-column(2)

Re: Addition of computed field

Fri, 17 Jul 2015 14:47:49 GMT

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

Re: Addition of computed field

swuehl — Fri, 17 Jul 2015 14:58:02 GMT

Ok, what's your question then?

Re: Addition of computed field

Fri, 17 Jul 2015 15:15:36 GMT

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.

Re: Addition of computed field

swuehl — Fri, 17 Jul 2015 19:29:40 GMT

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.