Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
tinkerz1
Creator II
Creator II

How to set a list box up with out grouping

Hi,


I have set a list box up with the following expression in the general tab and changed the field to <expression>.

Then I entered this formula:

=if(len(ID]>0) and len(Location])>0,[Owner]&' - '&[Location])

By joining the statement 'Owner' and 'Issue' in the output of the IF statement the total output in a single column list box is not grouped.

When I set the field to 'Owner' in the general>field tab and use the above expression in the expression tab but set the output to 'Location' only, the 'Owner' field gets grouped and vital information is lost..

It will be easier for the user to use a 2 column list box and ungrouped on Owner and Location.

How can I use the above expression in the expression tab but not group on the field?

Thanks.

0 Replies