topic Re: Re: Help on this issue in QlikView

Help on this issue

Anonymous — Sat, 31 May 2014 14:39:31 GMT

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

Re: Help on this issue

cfz — Sat, 31 May 2014 14:48:24 GMT

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

Carlos

Re: Re: Help on this issue

Anonymous — Sat, 31 May 2014 15:07:33 GMT

Hi Carlos,

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

Thanks & Regards,

Sivakumar

Re: Help on this issue

swuehl — Sat, 31 May 2014 15:28:29 GMT

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.

Re: Help on this issue

robert_mika — Sat, 31 May 2014 15:36:26 GMT

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