Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
isciberras
Creator
Creator

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

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
santhiqlik
Creator
Creator

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

isciberras
Creator
Creator
Author

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