Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Qlikuser09
Creator II
Creator II

error in expression '}' expected

Count({1-$(=GetFieldSelections([ Name]))}Distinct If([Flag]=1,[userid]))

 

I am getting error in this expression where i am trying to get the values other excluding the selected filter(NAME)

Labels (1)
6 Replies
hic
Former Employee
Former Employee

The error message is correct. Your set expression is invalid:

{1-$(=GetFieldSelections([ Name]))}

Not sure what you are trying to achieve here... Is the $ supposed to be the first part of a dollar expansion? Or is it supposed to be part of the set syntax, denoting current selection? 

Qlikuser09
Creator II
Creator II
Author

$ representing the value of the current selection ( ( 1 - $) i represent to get values other than the selected name 

hic
Former Employee
Former Employee

The following will return current selection, but instead of the selected values of "Name", it will use the excluded ones:  {$<Name=E(Name)>} 

However, if you don't have any selection in "Name" it will return the empty set. Perhaps better to use  {1<Name=E(Name)>} ?

If you instead use {1-$<...>} it will return ALL excluded rows, also those that are excluded by other selections.

Qlikuser09
Creator II
Creator II
Author

=Count({1<([Name]=E[Name]>})[ReportName])

I tried this but again i am getting set modifier expression error

hic
Former Employee
Former Employee

Check your brackets. E() - not E[].

Qlikuser09
Creator II
Creator II
Author

=Count({1<[Name]=E([Name])>}[ReportName])

is not giving me errors ,but the value is not changing when the filter is applied