Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

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

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)'##.##%'))

1 Solution

Accepted Solutions

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

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

3 Replies
Not applicable

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

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?

=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?

Hi,

Try this,

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

Great dreamer's dreams never fulfilled, they are always transcended.
Community Browser