Set analysis

[Anonymous]

Hi All!

I need a set analysis expression to count.

Eg; if all the values of design_accept = 3 for the corresponding MachDateKey, then it should count it as one. If any one of the values IS0 then it should not count that machine (refer the below table for reference)

[Gysbert_Wassenaar]

perhaps count({<design_accept={3}>}design_accept)

[vishsaggi]

OR you can also use like

= Sum(IF(design_accept = 3, 1, 0))

[Anonymous]

Not working..

It is counting every MachdateKey which has atleast one value of design_accept=3 , but I want it to count MachdateKey only when all values of design_accept=3

[Anonymous]

I want a set analysis expression...

Unable to use sum(if...) in set analysis

[timpoismans]

Try the following:

Count({<MachDateKey={"=count({<design_accept={3}>}MachDateKey)=Count(MachDateKey)"}>}MachDateKey)

[vishsaggi]

Did you try what Gysbert suggested? If not can you share some sample to look into?

[manoranjan_d]

=count(distinct{<design_accept ={3}-{0}>}MachDateKey)

try this

[Anonymous]

Yes, but it's counting all MachDateKey, it's not checking if the all the design_accept=3 or not..