topic Re: set analysis in QlikView

set analysis

rathnam_qv — Tue, 17 Sep 2013 11:53:23 GMT

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 — Tue, 17 Sep 2013 11:57:38 GMT

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

Does that help?

jonathandienst — Tue, 17 Sep 2013 11:59:09 GMT

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

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

Regards

Jonathan

Tue, 17 Sep 2013 12:01:59 GMT

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 — Tue, 17 Sep 2013 12:15:11 GMT

hi try this.

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