Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Qlik Community,
We are using Qlik Sense Single API and Integration API to preview/open one dashboard which contains data for different projects.
We show the preview for managers of different projects using relevant project code in URL to filter only the selected project data.
All works fine while the selected project (which is a dimension) is included in the source data.
However, some projects may have no data in the source dataset (e.g., because they are in the early phase and have no relevant events yet). In this case, the dimension value is missing and Qlik ignores the selection showing all data (for all projects) which is wrong behavior for us.
In practice, it would look like this:
Try running a dashboard using selection in the URL (reproducible both for full URL and for Single). The selected value should be missing in the available values in the dimension.
E.g., you have a dashboard where one of the dimensions is CountryName, and the dataset contains data for Germany, France, and Italy.
If you try opening the dashboard with selection CountryName=Austria (which is non-existent) the dashboard will show you the values for all countries (selection will be ignored)
Is there a way how to prevent this behavior? I.e., if a missing dimension value comes from the URL parameter – not to display any data?
Many thanks!
Viktor
Hi @Viktor1 ,
This works as designed - applying selections on non existent values will show you all available data.
You could potentially, create a "dummy" value like No Country in your dataset and select it by default in all your URL integrations.
I hope this helps