multiple fields based on country

[krishnakv83]

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

[kaushiknsolanki]

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]

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