Show colunm if (Multiple columns)

[david15]

Hey guys, I'm new to the Qlik tools and I am tasked with something that is halting my progress.

My problem is, I need to create a table of contents that has to show a score of some people over the days of the month, I've managed to make it work, but i need it to not show the data from the past month.

This is my current result:

The only way i found to make it work was by using multiple columns, one for each day.

This is what it looks like in each column:

My show column if is not working and this is the expression being used:

This is the show column if expression: 

It works as expected, the only problem is that the columns with data from last month apear and with the '0' value

I someone has an idea on how to solve it, please help me!

Thank you all in advance!

[Aasir]

Try using below for your measure
Sum({<MonthYear = {"$(=MonthStart(Max(Date)))"}>} Score)