Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
jadams123
Creator
Creator

filtering

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,

J

2 Replies
marcus_sommer

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

rubenmarin

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