Filter a column using Filter Pane

[Hariz]

Hi,

I am new to qliksense and struggling to find a way to filter a table using filter pane. I have table with below data. 

DocId	AccountNames	AccountIds	Year
Doc1	AA;BB;CC	123;276;432	2000
Doc2	AA;DE	123;47	2001
Doc3	AAA	123	2002
Doc4	DE;VC	47;29	2004
Doc5	BB;CC	276;432	2006
Doc6	BBB	276	2008
Doc7	DE;CC	47;432	2003
Doc8	BBB;CC	276;432	2004
Doc9	AAA;DE	123;47	2003

I need a filter pane in qliksense  to filter by AccountName but internally it should filter using accountId. 

 Expected Result : When I apply filter by Acount Name : "AA". I should see AccountNames like below table. It should give the result of AccountId 123. 

FilterPane should display individual accountName in the filter values and internally it should use accoundID to filter the table

DocId	AccountNames	AccountIds	Year
Doc1	AA;BB;CC	123;276;432	2000
Doc2	AA;DE	123;47	2001
Doc3	AAA	123	2002
Doc9	AAA;DE	123;47	2003

Kindly help to find a solution for this problem.

Thanks in advance!

[AshutoshBhumkar]

Hi,

Maybe like below,

E.g

Table:
Load DocId,AccountIds,Year,AccounNames,SubField(AccountNames,';') as Accounts

Inline [
DocId, AccountNames, AccountIds, Year
Doc1, AA;BB;CC, 123;276;432, 2000
Doc2, AA;DE, 123;47, 2001
Doc3, AAA, 123, 2002
Doc4, DE;VC, 47;29, 2004
Doc5, BB;CC, 276;432, 2006
Doc6, BBB, 276, 2008
Doc7, DE;CC, 47;432, 2003
Doc8, BBB;CC, 276;432, 2004
Doc9, AAA;DE, 123;47, 2003

];

Output:

My question is how are you mapping AA with 123 and still want AAA to reflect 123 on selection of AA.

You need to create a custom  mapping in that case like below.

AA,AA,123

AA,AAA,123

Thanks,

Ashutosh

[Hariz]

Hi Ashutosh,

Thanks for your response.

There is no direct mapping table available. AccountNames and AccountIds columns are semicolon separated. Account name "AA" is assocated with Account Id "123". Account name "AAA" is result of name change to account name "AA" for the corresponding account id "123" 

I am not able to filter in filter pane by AA to get all the results for AA and AAA.

[AshutoshBhumkar]

Ok. You can then create a custom dimension like below.

I am not sure if that'll work in your case or not. Confirm this and give a try.

Pick(Wildmatch(Accounts,'*AA*','*BB*')+1,Accounts,'AA','BB') as NewAccounts

This will generate

AA for both AA and AAA

&

BB for both BB and BBB