topic Re: Sales value on current date in QlikView

Sales value on current date

Tue, 03 Feb 2015 11:40:03 GMT

Hi all.

How i can calculated Sales on current date.

Sum(Sales) - all sales

Thank all

Re: Sales value on current date

jpenuliar — Tue, 03 Feb 2015 11:42:36 GMT

The answer can be found here:

Set Analysis Wizard Tool

Re: Sales value on current date

its_anandrjs — Tue, 03 Feb 2015 11:44:17 GMT

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

Re: Sales value on current date

sunny_talwar — Tue, 03 Feb 2015 11:47:33 GMT

=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,

Re: Sales value on current date

Tue, 03 Feb 2015 11:49:41 GMT

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

count(OpenShop) for current date

Re: Sales value on current date

sunny_talwar — Tue, 03 Feb 2015 11:52:21 GMT

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,

Re: Sales value on current date

its_anandrjs — Tue, 03 Feb 2015 14:12:21 GMT

Can you share any sample file.

Regards

Anand