Total in Chart

Sun, 06 Jun 2010 16:36:48 GMT

Hi,

I need total of all products including products with null values but I don't want to show null values for product dimension in chart. If I select suppress null values, total is excluding the values for null as well. What is the best way to resolve this issue?

Below is example,

Data in Table:

Product Value1

P1 10

P2 20

NULL 40

Expected Output:

Product Value1 Formula1 (Excluding Null Record)

P1 10 10+20+40

P2 20 10+20+40

Output I am getting with totals in expression: Sum (Total <Product> Value1) with Suppress Null Value select for Product Dimension

Product Value1 Formula1 (Excluding Null Record)

P1 10 10+20

P2 20 10+20

Output I am getting with totals in expression: Sum (Total <Product> Value1) without Suppress Null Value select for Product Dimension

Product Value1 Formula1 (Without Excluding Null Record)

P1 10 10+20+40

P2 20 10+20+40

NULL 40 10+20+40

I can suppress null records by using if condition, but I want to avoid using if. please advice.

If(IsNull(Product) = -1,0,Sum (Total <Product> Value1))

Total in Chart

Mon, 07 Jun 2010 18:23:44 GMT

How about if you use

SUM(TOTAL Value1)

topic Total in Chart in QlikView

Total in Chart

Total in Chart