Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

Tags (1)
5 Replies
hrlinder
Honored Contributor

Re: Error in script

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

Re: Error in script

Hi Rudolf,

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

Script error.PNG

Re: Error in script

Use

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

susovan_g
Valued Contributor

Re: Error in script

Hi Pankaj,

Can you try this process

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

hrlinder
Honored Contributor

Re: Error in script

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, '', '')

Community Browser