topic Re: Error in script in QlikView

Error in script

Tue, 21 Jun 2016 09:30:32 GMT

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

Anonymous — Tue, 21 Jun 2016 09:43:06 GMT

indeed one bracket is missing

but is Syntax correct?

try this

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

Tue, 21 Jun 2016 09:47:49 GMT

Hi Rudolf,

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

MK_QSL — Tue, 21 Jun 2016 09:59:10 GMT

Use

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

susovan — Tue, 21 Jun 2016 10:33:33 GMT

Hi Pankaj,

Can you try this process

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

Anonymous — Tue, 21 Jun 2016 11:48:44 GMT

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