topic How do you write an expression with a modifier between x and y values? in QlikView

How do you write an expression with a modifier between x and y values?

Fri, 04 May 2012 12:46:36 GMT

=sum({1<Area={'UK'}, Contractor={0},Op_Week={">=$(=$(vMaxCompleteOpWk)-4)"} >} [Issued])
/sum({1<Area={'UK'}, SubcontractorType={0},Op_Week={">=$($(=vMaxCompleteOpWk)-4)"}>}  Declared)

I am trying to write an expression based on the one below to return data where the Op_Week is between vMaxCompleteOpWk and vMaxCompleteOpWk-4. Any help would be welcome

Thanks

How do you write an expression with a modifier between x and y values?

chematos — Fri, 04 May 2012 19:56:24 GMT

try this,

=sum({1<Area={'UK'}, Contractor={0},Op_Week={'$(<=$(vMaxCompleteOpWk))'},

Op_Week={'$(>=$(vMaxCompleteOpWk)-4)'} >} [Issued])

/sum({1<Area={'UK'}, SubcontractorType={0},Op_Week={'$(<=$(vMaxCompleteOpWk))'},Op_Week={'$(>=$(vMaxCompleteOpWk)-4)'}>} Declared)

Hope this helps

Regards,

Chema

How do you write an expression with a modifier between x and y values?

Tue, 08 May 2012 09:11:22 GMT

Hi Chema

Thank you for your help. Unfortunately the expression did not return any results .

Regards

How do you write an expression with a modifier between x and y values?

Tue, 08 May 2012 09:22:32 GMT

Hi Chema

Think I have the solution

=sum({1<Area={'UK'}, Contractor={0},Op_Week={">=$(=$(vMaxCompleteOpWk)-4)"} *{"<=$(=$(vMaxCompleteOpWk))"} >} [Issued])/sum({1<Area={'UK'}, SubcontractorType={0},Op_Week={">=$($(=vMaxCompleteOpWk)-4)"} *{"<=$(=$(vMaxCompleteOpWk))"}>} Declared)

Regards

How do you write an expression with a modifier between x and y values?

chematos — Tue, 08 May 2012 14:03:05 GMT

Hi kathryn,

I´m glad you get this! I knew it was something like that but usually when you use a comma ',' that must do a logic AND, but I´m seeing that sometimes the solution is with '*' like you did.

Regards,

Chema