Show only month end dates values in a table qliksense

[Aspiring_Developer]

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

[justISO · Accepted solution]

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.