Good Afternoon, I am trying to use Set Analysis on one of my charts to be able to count all the product from the last month. So if I open up the document on August, I would like to see the total amount of products there were in July. I have two fields in my database called Dateentered(format is: MM/YYYY) and Product(format is: text). So my code is as following:
I think you need a dollar sign expansion around that Monthstart function. That will force QlikView to evaluate the function before doing the Set Analysis.