Display fileds as drop down list

[sekharQV]

Hi Techies,

Could you please help me on below requirement.

I have the following fields available in my app

"DuplicateBankAccount",  "DuplicateTaxId",  "DuplicateBankAccountAndTaxId",  "DuplicateAddress", "Missing Bank Accounts or TaxId"

My 1st requirement is to display above fields in a multibox with one more option 'All' where 'All' is combination of all above fields.

2nd requirement is i have 5 fields (field1,field2,..etc) which contains associated count of the values of above fields respectively.

so when i click on "DuplicateBankAccount" in multibox,then it should show the "field1" values under count column(or expression) of straight table(fields in table are supplier name and count which could be expression), and when i click on "DuplicateTaxId", then it should show the "field2" values under count column of table and so on and when i click "All" in multibox,then it should show sum all filelds(field1+field2+..+field5) under count column of table.

Could anybody suggest me, how to achieve it.

Help is appreciated.

Thanks & Regards,

Rajasekhar.

[MK9885 · Accepted solution]

For your first requirement

How to make a list box of a table group | Qlik Community

FYI the fields won't combine in this but all the values will combine into one dimension.