expression error in SET Analysis with variable

[#1]

Hi

I´m having a syntaxproblem with this Set Analysis

count({<AAR=vCurrentyear,Gruppe={'Tyveri fra borger'} >}JOURNALNR)

the problem lies at the comma after the vCurrentYear

I tried

count({<AAR={vCurrentyear},Gruppe={'Tyveri fra borger'} >}JOURNALNR)

but it doesnt work

[alexandros17]

try this

count({<AAR={$(vCurrentyear)},Gruppe={'Tyveri fra borger'} >}JOURNALNR)

let me know

[maleksafa]

you need to add the $ sign before the variable in order to evaluate it, use $(vCurrentYear)

[Colin-Albert]

In set analysis expression modifiers, the field is always compared to a set of results, so the values after the = sign must be enclosed in parenthesis { }. Also variables should be enclosed in $() to ensure they are evaluated.

If vCurrentyear is text then the expression must be enclosed in quotes.

If vCurrentyear is numeric        use          count({<AAR={$(vCurrentyear)}, Gruppe={'Tyveri fra borger'} >} JOURNALNR)

If vCurrentyear is text     use       count({<AAR={'$(vCurrentyear)'}, Gruppe={'Tyveri fra borger'} >} JOURNALNR)

[#5]

Hi Alessandro

It doent work - it says expression ok, but I dont get a result only a -

[Colin-Albert]

Is vCurrentyear holding the data as text not numeric values?

Try adding quotes around the variable.

count({<AAR={'$(vCurrentyear)'}, Gruppe={'Tyveri fra borger'} >} JOURNALNR)

[#7]

Hi Colin

using yours gives me zeroes

[#8]

the variable vCurrentyear is made like this =year(today())

[Colin-Albert]

For the set expression to work, both the AAR data and vCurrentyear must hold the same values to match.

Can you post a screenshot of a listbox showing some AAR values.

Also the case of the Gruppe text must exactly match 'Tyveri fra borger'

[#10]

Hi Colin

Of course you are right

The AAR(means year in danish) is not made from a date, but is a text field.

If I use an expression like this

count(if(AAR=vCurrentYear,JOURNALNR))

it works fine