Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
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*] )