Generally speaking the surface receives about 1kw/m2. I’d love to see a spectral graph that shows how that kilowatt is distributed. How much visible light can you sneak for a very low amount of that energy?
According to Wikipedia, 43% of the sun's energy at the surface of the earth is visible light (https://en.m.wikipedia.org/wiki/Sunlight#Measurement). So just blocking the other wavelengths would help, but I'm not sure it would be a "night and day" difference, so to speak. Daylight is several orders of magnitude brighter than normal indoor lighting, so I bet you could block 80-90% of visible light, as well, and it would still look really bright out while heating the inside significantly less.
I don't know the details but it worked out very well for me. It still lets some heating rays in but its much more manageable, some ventilation is enough now.
The photo of the wall shows two areas, one area illuminated by the light passing through the filter and another small area illuminated by direct sunlight through the opening.
It's a window in a small room. The window has a top-open position which provides enough ventilation to take away heat that still manages to get in. Previously, this room was getting unbearably hot and now is much better(still hot on days with no wind though).