topic Re: Why does my expression return a zero value in QlikView

Why does my expression return a zero value

Mon, 10 Mar 2014 22:02:27 GMT

I have an expression written as follows:

fabs(sum({<ItemCategory={'Classbook Reprints'}>}ITEM_COUNT))/fabs(sum({<ItemCategory={'Classbook Original Manuscripts'}>}ITEM_COUNT))

This returns a value of zero.

However, when I break the two pieces out on their own, each returns a value. Why when I divide the sums against eachother, am I getting a zero?

The first section returns a value of 130451. The 2nd section returns a value of 15583.

The result I am trying to arrive at through my expression is 8.37.

MK_QSL — Mon, 10 Mar 2014 22:11:53 GMT

expression looks ok.

can you share your sample file?

Carlos_Reyes — Mon, 10 Mar 2014 22:53:35 GMT

Strange.... perhaps you need to change the Number Format Setting in the Object properties.

Mon, 10 Mar 2014 23:01:45 GMT

TRy with this:

(fabs(sum({<ItemCategory={'Classbook Reprints'}>}ITEM_COUNT)))

(fabs(sum({<ItemCategory={'Classbook Original Manuscripts'}>}ITEM_COUNT)))

Clever_Anjos — Tue, 11 Mar 2014 01:35:15 GMT

Where this expression is beeing used?

A textbox or a graph? If you´re using a graph, please check number format

Mon, 17 Mar 2014 14:42:08 GMT

I found the issue. Apparently this type of expression won't work when using a Gauge Chart.

After trying the expression in a text object it works as expected.