Set Analysis with 2 Functions

microwin88x — Tue, 13 May 2014 12:37:38 GMT

Hello!

I have the following expressions with set analysis:

To count the number of observations:

COUNT ({$<ID_TIME_DATE#={">=$(='$(vDateFrom)')<=$(='$(vDateTo)')"},OBSERVATIONS={">0"}>} OBSERVATIONS)

To count the number of anomalies:

COUNT ({$<ID_TIME_DATE#={">=$(='$(vDateFrom)')<=$(='$(vDateTo)')"}>} DISTINCT ANOMALY_ID)

Now I need to count the number of observations with anomalies, using both expressions.

Do you know how could I do that?

Thank you!!!

Re: Set Analysis with 2 Functions

anbu1984 — Tue, 13 May 2014 13:00:25 GMT

Try this

COUNT ({$<ANOMALY_ID=P({$<ID_TIME_DATE#={">=$(='$(vDateFrom)')<=$(='$(vDateTo)')"}>} ANOMALY_ID),ID_TIME_DATE#={">=$(='$(vDateFrom)')<=$(='$(vDateTo)')"},OBSERVATIONS={">0"}>} OBSERVATIONS)

topic Set Analysis with 2 Functions in QlikView

Set Analysis with 2 Functions

Re: Set Analysis with 2 Functions