Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sum expression based on >date

Hi I have the following expression

=Sum(all if (DateMonth >= Date('10/11/08'),sales)/Sum(all if(datemonth >= date('10/11/08'),Purchases)

however it isn't returning anything, anyone got any ideas what is wrong with the expression.

Thanks in advance

1 Reply
Not applicable
Author

Hello,

I dont think you need the all in the statement

=Sum(if (DateMonth >= Date('10/11/08'),sales)/Sum( if(datemonth >= date('10/11/08'),Purchases)