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

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Error in Set Modifier ad hoc element list

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?







1 Reply
Not applicable
Author

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 )