topic Set analysis in QlikView

Set analysis

Anonymous — Fri, 28 Sep 2018 13:49:38 GMT

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)

Re: Set analysis

Gysbert_Wassenaar — Fri, 28 Sep 2018 13:54:56 GMT

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

Re: Set analysis

vishsaggi — Fri, 28 Sep 2018 15:23:27 GMT

OR you can also use like

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

Re: Set analysis

Anonymous — Mon, 01 Oct 2018 07:32:11 GMT

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

Re: Set analysis

Anonymous — Mon, 01 Oct 2018 07:32:54 GMT

I want a set analysis expression...

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

Re: Set analysis

timpoismans — Mon, 01 Oct 2018 07:39:46 GMT

Try the following:

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

Re: Set analysis

vishsaggi — Mon, 01 Oct 2018 14:40:31 GMT

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

Re: Set analysis

manoranjan_d — Mon, 01 Oct 2018 14:49:20 GMT

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

try this

Re: Set analysis

Anonymous — Wed, 03 Oct 2018 10:00:55 GMT

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