Qlik Community

Qlik Sense Advanced Authoring

Discussion board where members can learn more about Qlik Sense Advanced Authoring.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

count sales from previous month

I currently have a table of sales and its date. I have created a field named month_1 which gets the previous month as shown below. Now I am trying to count the number of sales in every month. Sales are reported daily so I will need to sum them up. I want to have a list of month mapped with last month's sales. Any idea how can I do that?

Currently I am using:

=count({<[Date]={month_1}>}Sales)

but it's not working

22.PNG11.PNG65.PNG

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Hi,

Or you need to place this value in a variable. Or you need a filter pane where you can filter on Month_1. Then you can just use Sum(Sales). You can't count Sales because then you count the rows and not the values in the rows.

Jordy

Climber

Work smarter, not harder

View solution in original post

1 Reply
Highlighted
Partner
Partner

Hi,

Or you need to place this value in a variable. Or you need a filter pane where you can filter on Month_1. Then you can just use Sum(Sales). You can't count Sales because then you count the rows and not the values in the rows.

Jordy

Climber

Work smarter, not harder

View solution in original post