Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
bridgitte
Contributor
Contributor

combining multiple (excel) columns into one field?

In my data source I have multiple columns with the same peoples names in each:

multiple columns.PNG

(Column D relates to column C, F to E, I to H)

How do I make a list of the people, so when selecting their name in a filter pane, it counts how many times their name is in each column (like my cut & past image below!):

filter.PNG

I'm sure its very straight forward! thank you...

 

1 Reply
mikaelsc
Specialist
Specialist

create a link table? 

userlink:

load 

createdby as user,

creator as type,

case_

residend MyTable;

 

concatenate(userlink)

load 

endineer_by as user,

engineer              as type,

case_

residend MyTable;

etc... 

 

count({type={'creator '}>}distinct case_) will then give the number of created cases.

careful : only to be used with the new dimension user