Discussion board where members can get started with QlikView.
I have a chart that I need to make static (does not change with selections made). This is the expression I am using but I cannot seem to fix it. Is there any way to use set analysis to keep it fixed?
=If(Week([Date Created On]) = Week(Today())-1,count([Material Description]))
The expression shows how many SKUs were created the past week.
Any help is greatly appreciated!