topic Re: Dual expression returns "error: error in expression: ')' expected. What am I missing? in QlikView

Dual expression returns "error: error in expression: ')' expected. What am I missing?

Mon, 17 Mar 2014 15:12:50 GMT

I have this expression that I am trying to format as a % with 2 decimal points. I can't seem to figure out what I am missing. Any assistance is appreciated.

=fabs(sum({<ItemCategory={'Individual Reprints','Individual Deluxe Reprints'}>}ITEM_COUNT))/(fabs(sum({<ItemCategory={'Individual Original Manuscripts'}>}ITEM_COUNT)'##.##%'))

Re: Dual expression returns "error: error in expression: ')' expected. What am I missing?

Mon, 17 Mar 2014 15:15:33 GMT

You missed the num() function. You can try this:

=num(((fabs(sum({<ItemCategory={'Individual Reprints','Individual Deluxe Reprints'}>}ITEM_COUNT)))/

(fabs(sum({<ItemCategory={'Individual Original Manuscripts'}>}ITEM_COUNT)))),'##.##%')

Re: Dual expression returns "error: error in expression: ')' expected. What am I missing?

Nicole-Smith — Mon, 17 Mar 2014 15:15:43 GMT

=num(fabs(sum({<ItemCategory={'Individual Reprints','Individual Deluxe Reprints'}>}ITEM_COUNT))/(fabs(sum({<ItemCategory={'Individual Original Manuscripts'}>}ITEM_COUNT))),'##.##%')

Re: Dual expression returns "error: error in expression: ')' expected. What am I missing?

PrashantSangle — Mon, 17 Mar 2014 15:21:51 GMT

Hi,

Try this,

=num(fabs(sum({<ItemCategory={'Individual Reprints','Individual Deluxe Reprints'}>}ITEM_COUNT))/fabs(sum({<ItemCategory={'Individual Original Manuscripts'}>}ITEM_COUNT)),'##.##%')