Filtering Relevant Data

[medinis123]

Dear all,

I’m quite new to QlikSense and I’m encountering some issues.

In short, I have multiple datasets loaded into the dashboard. Dataset1 contains project information, names, funding, etc., and Dataset2 contains specific deliverables that are mapped in the dashboard. The datasets are synced using a deliverable number that is common in both files.

The problem is there are more projects in Database1 than there are projects with deliverables in Dataset2 that are relevant to be shown in the dashboard. In all charts and tables in the sheet, I only need information from Dataset2 filled with info from Dataset1.

For example, to show only relevant projects and their funding per beneficiary, I added an ‘x’ column with values of 1 to the second dataset. In charts and tables, I use set modifiers {<x = {1}>} to prevent them from being displayed, etc. However, these can be displayed when selected (see figure).

There must be a solution for this, but I can’t find it, and working this way will only create more problems.

 

Could you please suggest how I can filter only relevant information from the first dataset as a master filter or while loading the data?

Thank you very much in advance 🙂

[Lisa_P · Accepted solution]

If you load dataset2 first, you can limit dataset1 by using where exists(DeliverableNumber) at the end of the load or preceding load statement to only load those that already exist in the dataset.

[medinis123]

Thank you, this works. However, for some reason, I now get one additional row as a result with empty values. Is there a quick solution as to why one additional row from dataset1 is loaded?

[medinis123]

I found the solution by simply LEFT joining the tables, no more blank values. Additionally, not to include null values, you can deselect "include null values" 🙂 🙂