topic filtering in QlikView

filtering

jadams123 — Wed, 25 Nov 2020 16:16:04 GMT

Hi guys:

this is frustrating me.

I cant seem to get this formula correct:

= Sum( {$<GLYEAR = {$(#=MAX(GLYEAR))}, //THIS IS WORKING

DAYNUMBER>=2400 and DAYNUMBER<=2449, //Treat DAYNUMBER as date. THIS IS NOT WORKING

CUSTOMER_NAME = {*} - {PERFECT INC.}, //THIS IS NOT WORKING

CUSTOMER_TYPE = {*} - {ITC}, //THIS IS WORKING

CREDIT_FLAG = {YES}>} AMOUNT )//THIS IS WORKING.

THIS IS WORKING means...if I try only this criteria it works as soon as i add other criteria (this is not working criteria = daynumber and customer name) it doesnt work.

Thanks,

Re: filtering

marcus_sommer — Wed, 16 Nov 2016 12:54:03 GMT

Try it with:

= Sum( {$<GLYEAR = {$(#=MAX(GLYEAR))}, //THIS IS WORKING

DAYNUMBER = {">=2400<=2449"}, //Treat DAYNUMBER as date. THIS IS NOT WORKING

CUSTOMER_NAME -= {'PERFECT INC.'}, //THIS IS NOT WORKING

CUSTOMER_TYPE = {*} - {ITC}, //THIS IS WORKING

CREDIT_FLAG = {YES}>} AMOUNT )//THIS IS WORKING.

- Marcus

Re: filtering

rubenmarin — Wed, 16 Nov 2016 12:55:34 GMT

Hi Joe, try with:

= Sum( {$<GLYEAR = {$(#=MAX(GLYEAR))}, //THIS IS WORKING

DAYNUMBER={">=2400<=2449"}, //Treat DAYNUMBER as date. THIS IS NOT WORKING

CUSTOMER_NAME = {*} - {'PERFECT INC.'}, //THIS IS NOT WORKING - added simple quotes

CUSTOMER_TYPE = {*} - {'ITC'}, //THIS IS WORKING -it can work but I added the simple quotes

CREDIT_FLAG = {'YES'}>} AMOUNT )//THIS IS WORKING. it can work but I added the simple quotes