Restrict Auto Joins

[anuradhaa]

Hi All,

I have created a Qlikview Dashboard but now i have a serious problem.

As exampale i have three tables name User Registration, Countries, Online Users

Here i have created my dashboard Based on first 2 tables and now i need to include thired one.

Here User Registration table has feils Username,Country,Reg date etc.

Countries Table has Country, etc

User Type table has OnlineUsername,Country,UserType etc.

So country is common to three tables.

I have include pie chart for online users based on user type.

When i have country as common it change bsed on RegDate. So i don't want that, because this is Online users.

I think common feild county is the issue.

Pls tell me how can i do this. I know i can remove the country join. but i also want to see the online users from country select box.

Please Help me.

Thanks

[narender123]

You can concatenate the 3rd table with ist one table.

User Registration

concatenation

User Type

[Gysbert_Wassenaar]

Unless the Country field from the User Type table has information that is not already in the User Registration table I'd leave out the Country field from the User Type table. If it does contain information that doesn't exist in the User Registration table then I'd give the field another name.

edit: and rename the OnlineUsername field to Username so the User Registration and User Type tables are properly linked. At leas I assume that those two fields contain the same value for the same user. If that's not the case you'll have to explain how User Registration and User Type are related.

[anuradhaa]

Thanks for your reply.

Online user table is continuely updated table. It only keep the user infor mation who are online now. But user reg Table contains all user information.

So i can leave country from that table, but if i do so that table has no joins. It's fine. but i want to see online users via country.

So how colud i do that ?

Thanks