Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join “Do More With Qlik” with Mike Tarallo to get a first-hand look at the New Authoring Experience, June 29th: REGISTER HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
sivakumar01
Contributor III
Contributor III

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
Employee
Employee

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

Carlos

sivakumar01
Contributor III
Contributor III
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.