Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Combine Different columns into listbox

Hi Everyone, 

How do I combine different columns into one dimension for a list box. 

So I have data in the form:

Customer_IDCurrent_AccountSavings_AccountLoan_Account
1001101
1002001
1003111

 

For each account, 1 or 0 represents the customer having the account or not. 

I want to populate a listbox of account types with the contents

Current_Account

Savings_Account

Loan_Account

 

So on click of any of the options, all customers that have the the account type are filtered, and vice versa.  Is this possible please?

 

 

1 Solution

Accepted Solutions
Partner
Partner

Hi

you could do it using crosstable 

After that, you could filter your data adding where value = 1

View solution in original post

1 Reply
Partner
Partner

Hi

you could do it using crosstable 

After that, you could filter your data adding where value = 1

View solution in original post