Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
asilvaroli
Contributor
Contributor

definition expression data included

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

1 Solution

Accepted Solutions
sunny_talwar

Second one should be right

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

View solution in original post

2 Replies
sunny_talwar

Second one should be right

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

View solution in original post

Anil_Babu_Samineni

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)