This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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:
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;
View solution in original post
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!😂