Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
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
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)))

 

View solution in original post

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

 

View solution in original post

Highlighted
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