Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I have a dashboard I'm creating for executives, and I've made some Toggle buttons that filter data. The idea is that the executives can "layer" buttons on top of each other. For example there's a button for Active Projects. Then there's a button for Green Status. Then there's a button for Late End. As long as all three of these buttons return at least 1 result, everything is fine.
But let's imagine that Active Projects = 30 results, and Green status = 10 results, and Late End = 0 results. What happens is when I click the Late End button, it removes the Green status filter (and/or the Active Projects filter) and then returns Inactive Projects that are not Green Status but did have a Late End. This confuses the users because they don't understand that they are no longer including Active and Green criteria. I already have a Current Selections box, but that's not obvious enough.
What I'd like to achieve is either a pop up, or a zero count result, so they can see that for all 3 criteria, there are no results. I'm thinking something like error handling script behind a button. Is this possible? Does anyone know how to do it?
Thanks in advance for any tips,
AJ
hello
I would create a text box with a count() on a field selected by your buttons
if this count is zero (or null), you can display a message
You can also use QlikView for doing what it does best: filtering by selecting.
It works like this: explicitly assign those status values to projects, so that you have Status1 = Active,Inactive and Status2 = Green,Red and Status3 = OnTime,Late as fields that categorise each project.
Just put those StatusN fields as listboxes next to each other, and let the Green-White-Grey color trick play to its full effect.