
Specialist
2022-07-18
04:40 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Show only month end dates values in a table qliksense
Hello All,
I have below table in qliksense:-
My requirement is that I have to show numbers for the month end dates. No cumulation, simple display data for month end dates.
I tried using Monthend(Date) function in dimension, it did generated month end dates but it is giving the sum all values in that month which is incorrect.
Can anyone please help ?
Thanks in advance
1 Solution
Accepted Solutions

Specialist
2022-07-18
05:54 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi, maybe you can modify your [Date] field to
if([Date]=MonthEnd([Date]), [Date])
and in menu uncheck 'Include null values', so you will see only dates if they are last day of month.
1,379 Views
1 Reply

Specialist
2022-07-18
05:54 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi, maybe you can modify your [Date] field to
if([Date]=MonthEnd([Date]), [Date])
and in menu uncheck 'Include null values', so you will see only dates if they are last day of month.
1,380 Views
