topic Re: Count in set analysis with more than one condition in QlikView

Count in set analysis with more than one condition

Fitus9092 — Fri, 10 Dec 2021 10:41:55 GMT

Hello,

i have a problem with this script in set analysis:

Count({< Esclusione = {"0"}, (D_ALTRO_INTERVENTO_CHIR_1 - DataRicovero) = {"<2"} >} Esclusione). In particular the second part (D_ALTRO_INTERVENTO_CHIR_1 - DataRicovero) = {"<2"} doesn't work.

Thanks.

Re: Count in set analysis with more than one condition

tresB — Fri, 10 Dec 2021 11:15:09 GMT

Try like:

Count({< Esclusione = {"0"}, Esclusione={"=(D_ALTRO_INTERVENTO_CHIR_1 - DataRicovero)=<2"} >} Esclusione)

Re: Count in set analysis with more than one condition

Fitus9092 — Mon, 13 Dec 2021 11:12:16 GMT

No i'm sorry, it returns me 0 but the real results is not 0

Re: Count in set analysis with more than one condition

Fitus9092 — Tue, 14 Dec 2021 10:07:46 GMT

I have changed one dimension and now works. Thanks.