Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi sivakumar,
Would it be possible for you to share your QlikView document?
Cheers
Carlos
Hi Carlos,
I have attached both excel file and the .qvw file.
Thanks & Regards,
Sivakumar
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.
You can as well just add country for each player in column A of your Excel spreadsheet.