topic Re: Set Analysis problem on syntax in QlikView

Set Analysis problem on syntax

brunopaulo — Sat, 23 Sep 2017 12:47:09 GMT

Hi Community,

I'm trying to solve a problem using Set Analysis. I want to count the number of rows that a certain value appears.

I'm writing this way:

= Num (count ({($ <columnname = 'String'>} NrLine)

In Load I created a fuction RecNo () as NrLine.

The error it gives me is: Error in set modifier ad hoc element list: ',' or ')'

I can not find the place to put it.

Thank you for attention
Regards
Bruno Paulo

Re: Set Analysis problem on syntax

sunny_talwar — Mon, 25 Sep 2017 12:17:48 GMT

You are missing { and } within your set modifier

=Num(Count({$<columnname = {'String'}>} NrLine)

Re: Set Analysis problem on syntax

its_anandrjs — Mon, 25 Sep 2017 12:20:20 GMT

Missing Parenthesis

=Num (count ({($ <columnname = {'String'}>} NrLine)

=Num (if(columnname = 'String' , NrLine ) )

Re: Set Analysis problem on syntax

Anonymous — Mon, 25 Sep 2017 12:48:12 GMT

= Num (count ({$ <columnname = 'String'>} NrLine))

Try This

Re: Set Analysis problem on syntax

hari8088 — Mon, 25 Sep 2017 12:59:12 GMT

Try this.......

Num(Count({$<columnname = {'String'}>} NrLine))