topic Re: how can i get users in QlikView

how can i get users

Anonymous — Fri, 21 Jul 2017 09:09:07 GMT

I have user table

id	username	country	state
1	Anil	IN	AP
2	varma	AE	-
3	user	IN	Tl

and country table

id	country_code	country_name
1	IN	India
2	AE	United 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

Re: how can i get users

anvalo00 — Fri, 21 Jul 2017 11:42:43 GMT

Hola,

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

Saludos,

Re: how can i get users

passionate — Fri, 21 Jul 2017 11:48:33 GMT

Hi,

You can use this in test box:

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

Regards,

Pankaj

Re: how can i get users

effinty2112 — Sun, 23 Jul 2017 09:46:19 GMT

Hi Anil,

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

country	country_name
IN	India
AE	United 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

Re: how can i get users

Anonymous — Tue, 01 Aug 2017 08:52:55 GMT

Thank you Andrew, it's working

Re: how can i get users

oknotsen — Tue, 01 Aug 2017 11:41:02 GMT

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 .