Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Try using below for your measure
Sum({<MonthYear = {"$(=MonthStart(Max(Date)))"}>} Score)