Say we have 4 fields (priority, state, year, and ispaid). My user wants to see all records with the following criteria:
Priority = Urgent
State = MA
Year = 2013
isPaid = No
However, if they select priority Urgent, and there are none for MA, MA will be greyed out. Clicking MA will then deselect priority high, and instead select MA. If there are no priority Urgent and state = MA, the user wants to have the chart display "No records found". I could hardcode these selections into the data model.. but then I have to create a separate table for every single combination they need.
The users don't mind making bookmarks for complex selections, the issue comes when they have complex exceptions where they need to include and exclude several values from multiple fields.
Is there any solution to this? Seems like a crippling limitation to QlikView. We basically need the ability to build a WHERE clause in the front end application, without reloading the entire document.