Sales value on current date

[#1]

Hi all.

How i can calculated Sales on current date.

Sum(Sales) - all sales

Thank all

[jpenuliar]

The answer can be found here:

Set Analysis Wizard Tool

[its_anandrjs]

Hi,

By the use of the transaction date that you have in the qlikview you can use SET Analysis

=Sum({<Date={'$(=Today())'}>}  Sales )

Regards

Anand

[sunny_talwar]

=Sum({<Date = {'$(=Max(Date))'}>}Sales) <- This would give you the sales for maximum date in your database if no selection has been made and in case you make a selection on date, it will give you the sales for the max date among your selection.

HTH

Best,

S

[#5]

ОК. It s good for Fact. but that a want use dimention

count(OpenShop) for current date

[sunny_talwar]

Count({<Date={'$(=Today())'}>} OpenShop) or

Count({<Date = {'$(=Max(Date))'}>} OpenShop)

Use the second expression if you don't have today's date in your database, else the output will be 0.

Best,

S

[its_anandrjs]

Can you share any sample file.

Regards

Anand