Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
capriconuser
Creator
Creator

Sum on the bases of specific column and filter date

  i am  trying to sum on the specific field on the specific filter through back-end 

 

i try this but did not work m

if(sum(ENDORESMENTDATE > '01-01-2018',IPPREMIUM)) AS VALUEEE

hwo i do this 

 

Labels (2)
2 Replies
Edvin
Creator
Creator

Try this:

sum(if(ENDORESMENTDATE>'01-01-2018',IPPREMIUM)) as VALUEEE

 

If it's not working, check the ENDORSEMENTDATE date format is it actually DD-MM-YYYY

shiveshsingh
Master
Master

May be this?

if(ENDORESMENTDATE > '01-01-2018',Sum(IPPREMIUM))