Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
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)