Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

How to sum up the count measure by month and year instead of date

I am trying to sum up the count values of my table. Currently i have two tables. I linked the table together by date. In my data i had the date to be formatted as 11/01/2019, 11/02/2019 ..... so i converted the date to show the date as Nov-2019. 

The problem is that when i add my measure the measure of the count is displayed by date instead of month and year. 

I want Nov-19 to add all its number and show as one month instead of separating out by date. I tried the pivot table option and it didn't seem to work for me. 😕 

Data ex.png

3 Replies
Highlighted

Re: How to sum up the count measure by month and year instead of date

how your month is calculated?

Highlighted

Re: How to sum up the count measure by month and year instead of date

Are you using Date() function to just change the format of your date? You would actually need to use MonthStart() or MonthName() function to convert any date in a particular month to 1st of the month

Date(MonthStart(DateField), 'MMM-YY') as Month
or
MonthName(DateField) as Month
Highlighted
Partner
Partner

Re: How to sum up the count measure by month and year instead of date

Hi Tayaba

It seems you have a hidden timestamp in your data field.

try remove the timestamp by using Floor() and then converting back to desired data format using Date()

Date( Floor( [DateField] ), 'MMM-YYYY' ) as YearMonth

Teis