Turning Aggr Dimension into Expression

Wed, 10 Apr 2013 14:29:23 GMT

What is the best way to turn Aggr Dimension into an Expression?

-------------------

My current dimension is Week, calculated as follows:

=aggr(if([Week] = min({$<[Product] = {'A'}>*<[Sales] = {'>0'}>}total <[Customer]> [Week]),[Week]),[Customer],[Week]

and my current expression then count(distinct[Customer])

-------------------

Now, I want to calculate the # of "new customers" on the fly in the expression, where I can choose any dimension and not limit it to observations. To make this possible, I would need to limit in the expression the Week=Max(Week) available in the database.

Ultimately, what I'm trying to accomplish in plain English : How many New Customers appeared in my database as of the most recent week?

thank you in advance!

topic Turning Aggr Dimension into Expression in QlikView

Turning Aggr Dimension into Expression