Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
joshrussin
Creator III
Creator III

Pivot Table - Current Month

Trying to figure out how to make this pivot table work correctly.

table.PNG

I am trying to get ONLY the days in the CURRENT month in this pivot table. Any ideas?

Right now I have a column = Date

I have tried setting the column = {$<Month_RD = {"$(=Month(FirstWorkDate(ConvertToLocalTime(Date(now()), 'GMT-05:00'),1,$(vHolidays))))"},  Year_RD = {"$(=Year(FirstWorkDate(ConvertToLocalTime(Date(now()), 'GMT-05:00'),1,$(vHolidays))))"}>}Date

But it says that is invalid.

0 Replies