Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Combine Profit Center & Profit Center Description into single List Box

If I have two fields "Profit Center & Profit Center Description" how do I have them combined to appear in a list box.

Example:

Profit Center:            Profit Center Description:

1005                        Tools

1006                        Electrical

How would I have them appear in a list box as:

1005 - Tools

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

It will be:
="Profit Center" & ' - ' & "Profit Center Description"
or maybe, depending on where you use it:
=aggr("Profit Center" & ' - ' & "Profit Center Description"),"Profit Center")

View solution in original post

1 Reply
Anonymous
Not applicable
Author

It will be:
="Profit Center" & ' - ' & "Profit Center Description"
or maybe, depending on where you use it:
=aggr("Profit Center" & ' - ' & "Profit Center Description"),"Profit Center")