Display fileds as drop down list

PRS — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Display fileds as drop down list

MK9885 — Wed, 21 Dec 2016 18:50:02 GMT

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.

topic Re: Display fileds as drop down list in QlikView

Display fileds as drop down list

Re: Display fileds as drop down list