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
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:
Check the attached. I used the below expression in straight table with the Dimension as Assets. Also, check the sample data. I added few more rows.
Trim(PurgeChar(Concat(Total Distinct Team,' '),Concat(Distinct Team)))
View solution in original post
I cant thank you enough for your help. The result is exactly what I was hoping to achieve.
For some reason however with my real data i'm getting a weird result which looks like the following:
Would you happen to know why this might be happening? The real time names are names of cities with spaces, could this be causing the issue do you thing?
Teams that Do not have Assets
Test Equipment, Ls
Test Equipment, Operating Rods
Tool - Electric
Test Equipment, Core Id/Phasing Devices