Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
=Count({<Dateentered = {Monthstart(Today(), 1)}>} Product )Unfortunately this does not work. I get "Error in set modifier ad hoc eleement list:" from the complier.
Not sure what I am doing wrong?
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.
=Count({<Dateentered = {$(Monthstart(Today(), 1))}>} Product )