Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
david15
Contributor
Contributor

Show colunm if (Multiple columns)

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:

Captura de tela 2023-11-20 103105.png

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:

Captura de tela 2023-11-20 104036.png

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

Captura de tela 2023-11-20 104426.png

This is the show column if expression: 

Captura de tela 2023-11-20 104526.png

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!

Labels (6)
1 Reply
Aasir
Creator III
Creator III

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