Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
wynnjimbbt
Contributor III
Contributor III

Error in set modifier ad hoc element list: ',' or ')' expected ; GetSelection variables

have trouble evaluating vGetQualfWeekEnding when 2 or more dates are selected:

all other GetSelection variables work, and vGetQualfWeekEnding works with 1 date selected.

ex.

=$(vGetQualfWeekEnding) returns 09/23/2017, 09/30/2017

=sum({$<  LogonID ={"*"}, [Week Ending] = {'$(=$(vGetQualfWeekEnding))'} >}[Target PMP Ref] )  returns a zero; there is data

=$(ePMPRefTarget) returns " Error in set modifier ad hoc element list: ',' or ')' expected "

ePMPRefTarget:

LogonID ={"*"},[Ref Qualified Date]=, [Ref Qualified Year]=, [Ref Qualified Quarter]=, [Ref Qualified Month]=, [Ref Qualified Week Ending]=, Advisor=, [Group]=, [Region Team]=,Year = {$(=max(Year))} , Quarter = { $(=$(vGetQualfQuarter))} , Month = { $(=$(vGetQualfMonth))}, [Week Ending] = {'$(=$(vGetQualfWeekEnding))'}

Thanks in advance!

Jim

25 Replies
wynnjimbbt
Contributor III
Contributor III
Author

Variable definition in QVW:

Text box:

Text box: evaluate variable:

sunny_talwar

Remove the equal sign from variable definition

Capture.PNG

And then try this in a text box object =$(vGetQualfWeekEnding)

wynnjimbbt
Contributor III
Contributor III
Author

Sunny, Thank you!
the variable definition is CORRECT.

the sum statements fail in a text box but the variable works with my existing logic.

sunny_talwar

Super cool... I am glad we managed to get the solution in the end

pradosh_thakur
Master II
Master II

looks like we got the solution !! Though never had any doubt that it wont ..

Learning never stops.
ddourguin
Contributor
Contributor

Hello, 

I have the same error but cannot find the solution : 

sum

(

{

$

<[Solde*] =

{

=Sum(

{1
<[Comptes_5*] = {'YES'}>
}

[Solde*] )

< 0

}

>

}

[Solde*] )