Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Help on this issue

Hi All,

I have created two tables one table contain  2 fields (Country, Flag) and send contain on field (Play) now if i select country has Brazil it should show only brazil player but iam getting all player and the country table should not minimize can any one help on this issue.

Thanks & Regards,

Sivakumar

4 Replies
cfz
Former Employee
Former Employee

Hi sivakumar,
Would it be possible for you to share your QlikView document?
Cheers

Carlos

Anonymous
Not applicable
Author

Hi Carlos,

I have attached both excel file and the .qvw file.

Thanks & Regards,

Sivakumar

swuehl
MVP
MVP

If I select Brazil, I do get only the brazilean players. Not sure what the exact issue is that you describe above.

I would suggest that you try to create data model where each player gets his own record, not all players of one country concatenated into one record.

You can do this using subfield() function in your load script.

edit: Here is a sample as a start, separated the players from the match table, but I don't know what the country is telling here.

robert_mika
Master III
Master III

You can as well just add country for each player in column A of your Excel spreadsheet.