Show only month end dates values in a table qliksense

Aspiring_Developer — Mon, 18 Jul 2022 08:40:30 GMT

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

Re: Show only month end dates values in a table qliksense

justISO — Mon, 18 Jul 2022 09:54:41 GMT

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.

topic Re: Show only month end dates values in a table qliksense in App Development

Show only month end dates values in a table qliksense

Re: Show only month end dates values in a table qliksense