Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

krishnakv83
New Contributor II

multiple fields based on country

Hi Experts,

I have country code in the one table and 4 different fields for various countries in the different table.Now the requirement is based on the country the field  values should be shown in one column in the dashboard.I did apply able to get one filed and don't know how to bring 4 fields.

Is there any method to achieve this?

Regards,

Venkat

2 Replies

Re: multiple fields based on country

Hi,

What you need is a link table or you can concatenate your table also.

FInd more help in below links.

Link Table in QlikView – Learn QlikView

https://www.analyticsvidhya.com/blog/2014/12/remove-synthetic-key-concatenation-link-table-qlikview/

Regards,

Kaushik Solanki

krishnakv83
New Contributor II

Re: multiple fields based on country

I can concatenate the tables.How to pass the parameter to display required country field in the given list box

How to derive in the script or in the UI layer?

Regards,

Venkat