Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

isciberras
Contributor

Compare teams against assets question

Hi everyone, 

 

I need some help, I have a table with teams and their associated assets as shown in the table below 

TeamAssets
Abooks 
Bbooks 
Cbooks
ARadio
BRadio
CRadio
DRadio

 

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:

AssetsTeam that does not have Asset
BooksD
  
  
  
  
  
  
  
  

 

Thanks,

Isaac

 

Labels (1)
1 Solution

Accepted Solutions
santhiqlik
Contributor

Re: Compare teams against assets question

Hi,

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)))

 

2 Replies
santhiqlik
Contributor

Re: Compare teams against assets question

Hi,

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)))

 

isciberras
Contributor

Re: Compare teams against assets question

Hi,

 

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?

 

Asset Type1

Teams that Do not have Assets

 

 

P2PE, item1

''''''/Ijjjjjjjjjjjj()/jjj/''

Test Equipment, Ls

'',,''''KK,jj-jjjjjjjj-jj-()Kq,-jjj,---,,-''K

Test Equipment, Operating Rods

'F'F''''F(F)'F'F

Tools

'F'F,,H''H''FHOHHOHHUHIKK,OHOHUjj-jjjjHjjjj-jj-(F)Kq,-jjjUUOHU,-O-O-O,OHU,-Ux'F'FK

Tool - Electric

'F'F,,VvvV''V''vvFIKK,(F)vvKq,v,VV,,x'F'FvK

Test Equipment, Core Id/Phasing Devices

'F'FVV''V''FI(F)qVV'F'F

 

 

 


Thanks,

Isaac