I have an issue because of qlikview functionality.
If we select an excluded value in the filter qlik will clear all the previously selected filters.
in my application we have a condition that chart will be displayed only when year and category filters are selected.If not it will throw a message saying that "please select date and category".
but in my scenario it should not clear the filter and Show "Please select a date and Category" instead it has to display a custom message saying "No data for this category and date".
Hi posting sample app/data will help you in getting right solution from community. As I got from the post you can use Alternative sates for your scenario.
The way QlikView is functioning/behaving makes sense. In your application, each year has only one product associated with it. So after selecting both year and product, when user changes year or product selection, other selection will be cleared. That is how QlikView is designed. You have to convey this to your users and get the requirement changed (Though it is not that easy).
And you have to change your error messages based on selections, something like below
When only Year is selected -> 'Select at least a Product'
When only Product is selected -> 'Select at least a Year'
When both are not selected -> 'Select at least a Year and a Product'
Enabling 'Always one selected value' restrict the analysis for only a year and a product. I feel that should be enabled to force users to select only one value from a field when analyzing large amounts of data to avoid memory issues.
