topic Re: definition expression data included in QlikView

definition expression data included

asilvaroli — Wed, 25 Nov 2020 16:16:04 GMT

Hello, i have a problem.

I don't know which of two Versions of the expression is correct.

The first is:

=count({$<[DURATA PREVISTA RICOVERO]={'>0'},[GIORNI EFFETTIVA - PREVISTA]={'>-10'} , [GIORNI EFFETTIVA - PREVISTA]={'<-4'},[CSA RICEVENTE]={'Residenza1’ }>}[StrutturaInviante])

The second expression is:

=count({$<[DURATA PREVISTA RICOVERO]={'>0'},[GIORNI EFFETTIVA - PREVISTA]={'>-10<-4'},[CSA RICEVENTE]={'Residenza1’}>}[StrutturaInviante])

So, can you help me?

Thanks a lot

Re: definition expression data included

sunny_talwar — Fri, 24 Mar 2017 16:38:33 GMT

Second one should be right

=count({$<[DURATA PREVISTA RICOVERO]={'>0'},[GIORNI EFFETTIVA - PREVISTA]={'>-10<-4'},[CSA RICEVENTE]={'Residenza1’}>}[StrutturaInviante])

Re: definition expression data included

Anil_Babu_Samineni — Sat, 25 Mar 2017 16:22:00 GMT

Or May be create two variables for vGreater = -10 and vLess = -4

Then call like below

=count({$<[DURATA PREVISTA RICOVERO]={'>0'},[GIORNI EFFETTIVA - PREVISTA]={'>$(vGreater)<$(vLess)'},[CSA RICEVENTE]={'Residenza1’}>}[StrutturaInviante]) // This won't give any performance diff. For understand i've taken into variables