Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set analysis: curent month sales

Hi;

I need to get the sum of Salesfor the current Month.

So if I look at the data today, I want to get the current month's data,to calculate a KPI that mean :

  • Sales of february 2014 * 25/ Number of day

Number of day: from start day of current month to today.

That mean "sales since the start of the current month *25/ 13 ( exemple for today).

I don't want to change sum sales every one I select a date from calendar to see another indicator.

I am using the following set analysis but it doesn't seem to be working .

any suggestions???

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

Please check enclosed file which will show you sample data and your requested result.

View solution in original post

14 Replies
Not applicable
Author

Hi,

I believe it would be something like this:

sum({1<Month={$(=Month(Today())}>} [Sales Field]/Day(Today()))


Hope it helps!

luis_pimentel
Partner - Creator III
Partner - Creator III

=sum({<Month={$(=Month(Today())}>} [yoursalesfield]) * 25 / Day(Today())

MK_QSL
MVP
MVP

=SUM({<[Invoice Date] = {'<$(=Today())'}, InvoiceMonth = {'$(=Month(Today()))'}>}SalesField) * 25/Day(Today())

Not applicable
Author

HI;

Please do you have an exemple qvw ??

I try all your answer but it dosen't work .

Thnks again.

MK_QSL
MVP
MVP

Better if we have your QVW so that we can give you answer on the same.

You can attach a sample file or an excel file with reduced or dummy data.

MK_QSL
MVP
MVP

Please check enclosed file which will show you sample data and your requested result.

Not applicable
Author

Thank You Manish;

It Works , Just I add  InvoiceDATE = {'$(=DATE(Today()),InvoiceYEAR = {'$(=YEAR(Today()))'} to have no changes when I select onather Year and day for another KPI .

ThnKS

MK_QSL
MVP
MVP

Glad that my help solved your problem.

Not applicable
Author

Please, just one thing: that function doesnot take into account this Day ; when I select 14/feb/2014 , I have 0 in all KPI for that function and when I add InvoiceDAY = {'$(=DAY(Today()), that does not work .

How can I solve this please?