Discussion board where members can get started with QlikView.
I need some help, I have a table with teams and their associated assets as shown in the table below (I also attached a QlikView document to better explain what I am trying to achieve)
So from the table above I can see that Team A,B,C have books however Team D does not. We can identify that a Team D exists because Team D has a radio.
Does anyone know what syntax I can write to identify that team D does not own the asset 'books'
The output of the table I am trying to create would ideally look like:
Im hoping to create a table which looks like:
Go to Solution.
Use this script to get table with missed assets linked with your base table by Team field:
1 as Has_asset
(ooxml, embedded labels);
LOAD Distinct Team Resident Raw_Data;
LOAD Distinct Assets Resident Raw_Data;
LOAD * Resident Raw_Data;
Team, Assets as missed_assets Resident full_data where Has_asset <> 1;
DROP Table full_data;
DROP Field Has_asset;
I can't thank you enough! it works perfectly.
I spent weeks trying to figure out how to get it to work, thank you so much for your help!😂