Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all.
How i can calculated Sales on current date.
Sum(Sales) - all sales
Thank all
The answer can be found here:
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
=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
ОК. It s good for Fact. but that a want use dimention
count(OpenShop) for current date
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
Can you share any sample file.
Regards
Anand