topic Re: Error in Expression: ')' expected in QlikView

Error in Expression: ')' expected

Tue, 28 Jul 2015 19:34:51 GMT

Greetings,

I'm trying a simple sum but have 2 different formats to return the data, dependant of the data which is selected to be shown. The elements are set using a variables:

vDisplayFormat (This should set the formatting to use)

Cost R # ##0;R # ##0
Time ##0

vDisplay (This refers to the field where the data resides)

Cost Total
Time No. Hrs Worked

Expression I'm using is:

=NUM(SUM($(vDisplay)),vDisplayFormat)

This works for the Cost formatting, but the Time formatting returns the Error in Expression: ')' expected

The idea is to return the:

SUM of Total in R # ##0;R # ##0 format
SUM of No. Hrs Worked in ##0 format

Any ideas?

Message was edited by: Chris Evans

Re: Error in Expression: ')' expected

MarcoWedel — Tue, 28 Jul 2015 20:30:45 GMT

please post sample app

thanks

regards

Marco

Re: Error in Expression: ')' expected

nithin_miryala — Tue, 28 Jul 2015 20:34:01 GMT

try $(vDisplayFormat)

Re: Error in Expression: ')' expected

Wed, 29 Jul 2015 07:53:56 GMT

Hi, I tried that before using the forum, doesn't work.

Re: Error in Expression: ')' expected

Wed, 29 Jul 2015 08:03:03 GMT

Sample app is uploaded

Re: Error in Expression: ')' expected

sasiparupudi1 — Wed, 29 Jul 2015 08:03:48 GMT

your No. Hrs Worked should be [No. Hrs Worked] or "No. Hrs Worked"

Re: Error in Expression: ')' expected

Wed, 29 Jul 2015 08:05:17 GMT

try like this

=NUM(SUM($(vDisplay)),'$(vDisplayFormat)')

Re: Error in Expression: ')' expected

Wed, 29 Jul 2015 08:10:02 GMT

Thanks ... simple solution

Re: Error in Expression: ')' expected

Wed, 29 Jul 2015 08:10:24 GMT

This is the answer, just need to adjust the variable action to one of the above and it will work fine

Re: Error in Expression: ')' expected

Wed, 29 Jul 2015 08:10:28 GMT

Didn't work ... but we got to the solution

Re: Error in Expression: ')' expected

johanlindell — Wed, 29 Jul 2015 08:28:58 GMT

Try =NUM(SUM($(vDisplay)),'$(vDisplayFormat)')