set analysis

[rathnam_qv]

hi all,

ihv the following script..i want to change it into set analysis..

can any one give me set analysis expression for this..urgent

count(case when abc ='L' then 1 else null end )

thanks in advance!!!

Smiley

[simondachstr]

count({<abc={'L'}>} abc)

Does that help?

[jonathandienst]

Hi

You can't use set analysis in script, it is only for expressions. In your case, use

     Sum(If(abc = 'L', 1))

Regards

Jonathan

[#4]

Hi

I'm not over sure of what you are trying to achieve, but could you not use a simple if function as below;

if( abc = 'L', 1,0) as count

Regards

Steve

[preminqlik]

hi try this.

count({<abc={'L'}>}DISTINCT abc)