Qlik Cloud: upcoming changes concerning reports with "Always one selected"
Hi! There is an upcoming change in in-app reports in combination with "Always one selected" applied to one or more fields and possibly Levels/Pages loops.
In some cases this might have resulted in unreliable reports with no data or missing sections, and no error in the reporting Task History.
Starting next week, these reports will fail and produce an error like this one:
Error in reporting service dependency Error code: SHA-10000 Template ID: 6a3e55d1-agf7-42f5-a899-0a563ad58ec5 Template: Template with AlwaysOneSelected Trace ID: a39627525cf7c8hd237b7e7e343d693498 Details: VerifyOneSelected for oneandonlyone: field Year has 0 values selected in state $ Filter: AllYears Email: myaddress@qlik.com
This message is shown when:
filters select an empty dataset, so the generated report would not contain data,
the "Always one selected" option is applied to at least one field used in a filter, a cycle, a page or a level.
When the dataset is empty, it is not possible to apply a selection in a field, as it would be requested by the "Always one selected" option. For this reason, Tabular Reports does not generate a report and shows the mentioned message instead.
This new behaviour will increase the reliability of the reporting solution. See also: Report filter limitations
Daniele - Principal Technical Support Engineer & SaaS Support Coordinator at Qlik If a post helps to resolve your issue, please accept it as a Solution.
Any changes of having that feature same time (which was rejected earlier) that if you have alternate states in the app and always one selected value, you should not be required to make as many filter from the same field as there is states. Rather you could just check box saying apply to all states...
