topic Operation in where condition expression in QlikView

Operation in where condition expression

Wed, 26 Sep 2012 13:59:18 GMT

I want to write in a chart this expression:

only({< [CASH-COSTS] < {'7'} >} NUMF)

I receive error for [CASH-COST] and <

MayilVahanan — Wed, 26 Sep 2012 14:12:46 GMT

Try like this

only({< [CASH-COSTS] = {"<7"} >} NUMF)

Hope that helps

Wed, 26 Sep 2012 14:16:00 GMT

[CASH-COSTS] gives error

MayilVahanan — Wed, 26 Sep 2012 14:44:19 GMT

Is there any Cash-Costs field ?

Please check it

Wed, 26 Sep 2012 14:47:05 GMT

"cash" is a field and "costs" is another field

cash-costs is the subtraction

jonathandienst — Wed, 26 Sep 2012 14:50:49 GMT

You cant do that in a set expression. The LHS must be a field name. Try this instead:

only(If (CASH - COSTS] < 7, NUMF))

Regards

Jonathan

MayilVahanan — Wed, 26 Sep 2012 14:57:02 GMT

Try like this

only(If (CASH - COSTS < 7, NUMF))

Anonymous — Wed, 26 Sep 2012 15:07:17 GMT

Hi,

Try:

only(If ((CASH - COSTS) < 7, NUMF))

Wed, 26 Sep 2012 15:12:53 GMT

but then i have to do a division...

I explain: when the subtraction CASH - COSTS is less of 7, count NUMF and divide this count NUMF for the total count of NUMF...

=(Count({<[CASH-COST] < {'7'}>} NUMF))/(Count(NUMF))

but this not work!