Operation in where condition expression - Qlik Community

Report Inappropriate Content · ‎2012-09-26

I want to write in a chart this expression:

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

I receive error for [CASH-COST] and <

MayilVahanan · ‎2012-09-26

HI

Try like this

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

Hope that helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

Report Inappropriate Content · ‎2012-09-26

[CASH-COSTS] gives error

MayilVahanan · ‎2012-09-26

HI

Is there any Cash-Costs field ?

Please check it

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

Report Inappropriate Content · ‎2012-09-26

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

cash-costs is the subtraction

jonathandienst · ‎2012-09-26

Hi

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

MayilVahanan · ‎2012-09-26

HI

Try like this

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

Anonymous · ‎2012-09-26

Hi,

Try:

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

Report Inappropriate Content · ‎2012-09-26

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!