Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

how can i get users

I have user table

idusernamecountrystate
1AnilINAP
2varmaAE-
3userINTl

and country table

idcountry_codecountry_name
1INIndia
2AEUnited Arab Emirates

i have created a list box object using  country_name field, when i am click on country name, i need to display respective country users

Can u please tell me

1 Solution

Accepted Solutions
effinty2112
Master
Master

Hi Anil,

              In you country table drop the field 'id' and rename the field country_code to country.

countrycountry_name
INIndia
AEUnited Arab Emirates

Now the data model will have the association between the tables you need. Associations are automatically made between fields with the same name.

Regards

Andrew

View solution in original post

5 Replies
anvalo00
Contributor II
Contributor II

Hola,

Tan sólo has de tener unidas las dos tablas con el campo país (llamándose igual en ambas).

Saludos,

passionate
Specialist
Specialist

Hi,

You can use this in test box:

=Concat({<country={'IN'}>}username,',')

Regards,

Pankaj

effinty2112
Master
Master

Hi Anil,

              In you country table drop the field 'id' and rename the field country_code to country.

countrycountry_name
INIndia
AEUnited Arab Emirates

Now the data model will have the association between the tables you need. Associations are automatically made between fields with the same name.

Regards

Andrew

Anonymous
Not applicable
Author

Thank you Andrew, it's working

oknotsen
Master III
Master III

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post; not visible in preview) and Helpful Answers (found under the Actions menu under every post).

If not, please make clear what part of this topic you still need help with .

May you live in interesting times!