Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Error in script

Hi I am trying to implement filter condition but it shows error in expression.

Can anyone help me to identify error.

='Point (' & Count(Distinct [Point Name]) & ')' & If(GetSelectedCount(< System_Type =('Meter') > [Point Name] > 0, '', '')

giving error on last bracket

5 Replies
Anonymous
Not applicable
Author

indeed one bracket is missing

but is Syntax correct?

try this

='Point (' & Count(Distinct [Point Name]) & ')' & If(GetSelectedCount({< System_Type =('Meter') >} [Point Name]) > 0, ', ')

Not applicable
Author

Hi Rudolf,

I tried the same expression what you have mentioned. it shows below error

Script error.PNG

MK_QSL
MVP
MVP

Use

='Point (' & Count(Distinct [Point Name]) & ')' &  If(GetSelectedCount([Point Name]) > 0 and System_Type ='Meter','','')

susovan
Partner - Specialist
Partner - Specialist

Hi Pankaj,

Can you try this process

='Point (' & Count(Distinct [Point Name]) & ')' & If(Count({<System_Type ={'Meter'}>}[Point Name])>0, '', '')

Warm Regards,
Susovan
Anonymous
Not applicable
Author

try to enclose System Type with [System Type]

Syntax is correct and brings data in my case (without your fieldnames)

='Point (' & Count(Distinct [Point Name]) & ')' & If(Count({<[System_Type] ={'Meter'}>}[Point Name])>0, '', '')