calculate a Nbr of Deals for one day

[#1]

Hello Everyone,

I have to calculate a number of transactions of yesterday (one day ago).

For example if we are on september 25^th, i must calculate automatically the number of transactions of September 24^th

I have a variable witch  calculate a number of transaction : ($(vKPI_VolumeDealsSent(  , )) )

Then, this expression  “=$(vKPI_VolumeDealsSent(  , ))  “ calculate the number of transactions but for all dates.

in the QlikView GUI i have created a straight table

The date field : [Application Date]

The dimension field : [Primary asset class]

here is what i have calculate till now (for all date )  using this expression (= $(vKPI_VolumeDealsSent( , ))    )

PRIMARY_ASSET_CLASS	number of transactions
	304634
InterestRate	113680
ForeignExchange	120474
Commodity	37357
Equity	22539
Credit	10584

My question : how I can calculate (in set analysis) the number of transactions of yesterday. (one day ago) ?

Thank you in advacnce for your suggestions

Best regards,

[swuehl]

Could you elaborate on

- the definition of your variable

- how your data model looks like, e.g. link from calendar to transaction

It's best if you could upload a small sample QVW, or some sample lines of data.

[#3]

Try this

=count({<date={'max(date)-1'}$(vKPI_VolumeDealsSent(  , ))>})

[#4]

Hello swuehl,

here is link for more details regarding my question

Average 30 last days for each date selected

Regards,