topic Re: Is there anything wrong with my data model . Help with set expression ! in QlikView https://community.qlik.com/t5/QlikView/Is-there-anything-wrong-with-my-data-model-Help-with-set/m-p/1335793#M840169 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>=Sum(Aggr(if(</STRONG></P><P><STRONG> (FirstSortedValue({&lt;season={$(#=Min(season))}&gt;} winner, -date) = Only({&lt;player={'$(ePlayer_of_final)'},match_id={'$(e_Match_Id_Final)'}&gt;}TEAM) ),</STRONG></P><P><STRONG> Count(match_id)</STRONG></P><P><STRONG> ), winner, toss_winner, match_id))</STRONG></P></BODY></HTML> Fri, 28 Apr 2017 08:31:27 GMT sunny_talwar 2017-04-28T08:31:27Z Is there anything wrong with my data model . Help with set expression ! https://community.qlik.com/t5/QlikView/Is-there-anything-wrong-with-my-data-model-Help-with-set/m-p/1335792#M840168 <HTML><HEAD></HEAD><BODY><P>Hi All ,</P><P></P><P>I want to find number of records (matchid) where toss_winner team is game winner ONLY IN FINALS .</P><P></P><P>But i think i am getting wrong data . Is this due to wrong data model or wrong expression .</P><P></P><P><IMG alt="COUNT MISMATCH.PNG" class="jive-image image-1" src="/legacyfs/online/161591_COUNT MISMATCH.PNG" style="height: 45px; width: 620px;" /></P><P></P><P></P><P></P><P>Thanks &amp; Regards</P><P>Shekar</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Is-there-anything-wrong-with-my-data-model-Help-with-set/m-p/1335792#M840168 shekhar_analyti 2020-11-25T16:16:04Z Re: Is there anything wrong with my data model . Help with set expression ! https://community.qlik.com/t5/QlikView/Is-there-anything-wrong-with-my-data-model-Help-with-set/m-p/1335793#M840169 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>=Sum(Aggr(if(</STRONG></P><P><STRONG> (FirstSortedValue({&lt;season={$(#=Min(season))}&gt;} winner, -date) = Only({&lt;player={'$(ePlayer_of_final)'},match_id={'$(e_Match_Id_Final)'}&gt;}TEAM) ),</STRONG></P><P><STRONG> Count(match_id)</STRONG></P><P><STRONG> ), winner, toss_winner, match_id))</STRONG></P></BODY></HTML> Fri, 28 Apr 2017 08:31:27 GMT https://community.qlik.com/t5/QlikView/Is-there-anything-wrong-with-my-data-model-Help-with-set/m-p/1335793#M840169 sunny_talwar 2017-04-28T08:31:27Z Re: Is there anything wrong with my data model . Help with set expression ! https://community.qlik.com/t5/QlikView/Is-there-anything-wrong-with-my-data-model-Help-with-set/m-p/1335794#M840170 <HTML><HEAD></HEAD><BODY><P>Thank you sunny bhai ..</P><P></P><P>ALSO ...<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">I want to find number of records (matchid) where toss_winner team is game winner ONLY IN FINALS .</SPAN></P></BODY></HTML> Fri, 28 Apr 2017 08:42:42 GMT https://community.qlik.com/t5/QlikView/Is-there-anything-wrong-with-my-data-model-Help-with-set/m-p/1335794#M840170 shekhar_analyti 2017-04-28T08:42:42Z Re: Is there anything wrong with my data model . Help with set expression ! https://community.qlik.com/t5/QlikView/Is-there-anything-wrong-with-my-data-model-Help-with-set/m-p/1335795#M840171 <HTML><HEAD></HEAD><BODY><P>How to you identify finals here? I have not looked at all the fields, but what is the identifying field here?</P></BODY></HTML> Fri, 28 Apr 2017 08:44:13 GMT https://community.qlik.com/t5/QlikView/Is-there-anything-wrong-with-my-data-model-Help-with-set/m-p/1335795#M840171 sunny_talwar 2017-04-28T08:44:13Z Re: Is there anything wrong with my data model . Help with set expression ! https://community.qlik.com/t5/QlikView/Is-there-anything-wrong-with-my-data-model-Help-with-set/m-p/1335796#M840172 <HTML><HEAD></HEAD><BODY><P>basically those recs where (tos_winner=winner)</P></BODY></HTML> Fri, 28 Apr 2017 08:44:15 GMT https://community.qlik.com/t5/QlikView/Is-there-anything-wrong-with-my-data-model-Help-with-set/m-p/1335796#M840172 shekhar_analyti 2017-04-28T08:44:15Z Re: Is there anything wrong with my data model . Help with set expression ! https://community.qlik.com/t5/QlikView/Is-there-anything-wrong-with-my-data-model-Help-with-set/m-p/1335797#M840173 <HTML><HEAD></HEAD><BODY><P>Ok ..</P><P></P><P>Max(date)&nbsp; is actually finals within each season . Season is nothing but year . </P><P>Ex - In season 2008 .. 5/9/2008 is final , since its highest among all dates of season 2008 . Unfortunately i have not created any flag .</P></BODY></HTML> Fri, 28 Apr 2017 08:51:32 GMT https://community.qlik.com/t5/QlikView/Is-there-anything-wrong-with-my-data-model-Help-with-set/m-p/1335797#M840173 shekhar_analyti 2017-04-28T08:51:32Z Re: Is there anything wrong with my data model . Help with set expression ! https://community.qlik.com/t5/QlikView/Is-there-anything-wrong-with-my-data-model-Help-with-set/m-p/1335798#M840174 <HTML><HEAD></HEAD><BODY><P>Checking now... unless this is resolved?</P></BODY></HTML> Fri, 28 Apr 2017 11:14:33 GMT https://community.qlik.com/t5/QlikView/Is-there-anything-wrong-with-my-data-model-Help-with-set/m-p/1335798#M840174 sunny_talwar 2017-04-28T11:14:33Z Re: Is there anything wrong with my data model . Help with set expression ! https://community.qlik.com/t5/QlikView/Is-there-anything-wrong-with-my-data-model-Help-with-set/m-p/1335799#M840175 <HTML><HEAD></HEAD><BODY><P>Ok .</P><P></P><P>Actually requirement is to find</P><P></P><P>a) winning percentage of teams who won toss vs those who have not won toss IN FINAL </P><P></P><P>b) <SPAN style="font-size: 13.3333px;">a) winning percentage of teams who won toss vs those who have not won toss IN League Matches ...</SPAN></P></BODY></HTML> Fri, 28 Apr 2017 11:24:03 GMT https://community.qlik.com/t5/QlikView/Is-there-anything-wrong-with-my-data-model-Help-with-set/m-p/1335799#M840175 shekhar_analyti 2017-04-28T11:24:03Z Re: Is there anything wrong with my data model . Help with set expression ! https://community.qlik.com/t5/QlikView/Is-there-anything-wrong-with-my-data-model-Help-with-set/m-p/1335800#M840176 <HTML><HEAD></HEAD><BODY><P>Checking.... does this data include today's match between KKR and DD? <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 28 Apr 2017 11:36:58 GMT https://community.qlik.com/t5/QlikView/Is-there-anything-wrong-with-my-data-model-Help-with-set/m-p/1335800#M840176 sunny_talwar 2017-04-28T11:36:58Z Re: Is there anything wrong with my data model . Help with set expression ! https://community.qlik.com/t5/QlikView/Is-there-anything-wrong-with-my-data-model-Help-with-set/m-p/1335801#M840177 <HTML><HEAD></HEAD><BODY><P>No Bhai ... its old . But i found interesting . </P><P><BR />Please let me know if you&nbsp; know any site from where from where we can download ball by ball data of match .. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/laugh.png" /></P></BODY></HTML> Fri, 28 Apr 2017 11:44:15 GMT https://community.qlik.com/t5/QlikView/Is-there-anything-wrong-with-my-data-model-Help-with-set/m-p/1335801#M840177 shekhar_analyti 2017-04-28T11:44:15Z Re: Is there anything wrong with my data model . Help with set expression ! https://community.qlik.com/t5/QlikView/Is-there-anything-wrong-with-my-data-model-Help-with-set/m-p/1335802#M840178 <HTML><HEAD></HEAD><BODY><P>Is this what you want?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/161618_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Fri, 28 Apr 2017 11:46:28 GMT https://community.qlik.com/t5/QlikView/Is-there-anything-wrong-with-my-data-model-Help-with-set/m-p/1335802#M840178 sunny_talwar 2017-04-28T11:46:28Z Re: Is there anything wrong with my data model . Help with set expression ! https://community.qlik.com/t5/QlikView/Is-there-anything-wrong-with-my-data-model-Help-with-set/m-p/1335803#M840179 <HTML><HEAD></HEAD><BODY><P>exactly 100 %</P></BODY></HTML> Fri, 28 Apr 2017 12:03:31 GMT https://community.qlik.com/t5/QlikView/Is-there-anything-wrong-with-my-data-model-Help-with-set/m-p/1335803#M840179 shekhar_analyti 2017-04-28T12:03:31Z Re: Is there anything wrong with my data model . Help with set expression ! https://community.qlik.com/t5/QlikView/Is-there-anything-wrong-with-my-data-model-Help-with-set/m-p/1335804#M840180 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/qlik-users/171708">stalwar1</A>‌</P><P></P><P>I same tabular column which you shared how to get Player of match in one column and Team to which player of match belongs to ... Using existing data model ... That will precisely help me in getting if my data model is correct ....</P><P></P><P>And I really&nbsp; dont know&nbsp; how to mark this reply as Important like mails......... <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 28 Apr 2017 12:18:53 GMT https://community.qlik.com/t5/QlikView/Is-there-anything-wrong-with-my-data-model-Help-with-set/m-p/1335804#M840180 shekhar_analyti 2017-04-28T12:18:53Z Re: Is there anything wrong with my data model . Help with set expression ! https://community.qlik.com/t5/QlikView/Is-there-anything-wrong-with-my-data-model-Help-with-set/m-p/1335805#M840181 <HTML><HEAD></HEAD><BODY><P>Just two columns? Player of the match and Team? Do you need it next to the match_id?</P></BODY></HTML> Fri, 28 Apr 2017 12:24:19 GMT https://community.qlik.com/t5/QlikView/Is-there-anything-wrong-with-my-data-model-Help-with-set/m-p/1335805#M840181 sunny_talwar 2017-04-28T12:24:19Z Re: Is there anything wrong with my data model . Help with set expression ! https://community.qlik.com/t5/QlikView/Is-there-anything-wrong-with-my-data-model-Help-with-set/m-p/1335806#M840182 <HTML><HEAD></HEAD><BODY><P>Yes . </P><P></P><P>Actually table <STRONG>Player</STRONG> is created by me from data in table <STRONG>Match Stat</STRONG> . </P></BODY></HTML> Fri, 28 Apr 2017 12:27:28 GMT https://community.qlik.com/t5/QlikView/Is-there-anything-wrong-with-my-data-model-Help-with-set/m-p/1335806#M840182 shekhar_analyti 2017-04-28T12:27:28Z Re: Is there anything wrong with my data model . Help with set expression ! https://community.qlik.com/t5/QlikView/Is-there-anything-wrong-with-my-data-model-Help-with-set/m-p/1335807#M840183 <HTML><HEAD></HEAD><BODY><P>these two will be additional columns </P></BODY></HTML> Fri, 28 Apr 2017 12:28:26 GMT https://community.qlik.com/t5/QlikView/Is-there-anything-wrong-with-my-data-model-Help-with-set/m-p/1335807#M840183 shekhar_analyti 2017-04-28T12:28:26Z Re: Is there anything wrong with my data model . Help with set expression ! https://community.qlik.com/t5/QlikView/Is-there-anything-wrong-with-my-data-model-Help-with-set/m-p/1335808#M840184 <HTML><HEAD></HEAD><BODY><P>Is this the goal?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/161627_Capture.PNG" style="height: 354px; width: 620px;" /></P></BODY></HTML> Fri, 28 Apr 2017 12:40:30 GMT https://community.qlik.com/t5/QlikView/Is-there-anything-wrong-with-my-data-model-Help-with-set/m-p/1335808#M840184 sunny_talwar 2017-04-28T12:40:30Z Re: Is there anything wrong with my data model . Help with set expression ! https://community.qlik.com/t5/QlikView/Is-there-anything-wrong-with-my-data-model-Help-with-set/m-p/1335809#M840185 <HTML><HEAD></HEAD><BODY><P>YEAH ..... Just needed only for finals though !&nbsp;&nbsp; <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 28 Apr 2017 14:26:51 GMT https://community.qlik.com/t5/QlikView/Is-there-anything-wrong-with-my-data-model-Help-with-set/m-p/1335809#M840185 shekhar_analyti 2017-04-28T14:26:51Z Re: Is there anything wrong with my data model . Help with set expression ! https://community.qlik.com/t5/QlikView/Is-there-anything-wrong-with-my-data-model-Help-with-set/m-p/1335810#M840186 <HTML><HEAD></HEAD><BODY><P>Here you are</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/161652_Capture.PNG" style="height: 133px; width: 620px;" /></P></BODY></HTML> Fri, 28 Apr 2017 14:33:50 GMT https://community.qlik.com/t5/QlikView/Is-there-anything-wrong-with-my-data-model-Help-with-set/m-p/1335810#M840186 sunny_talwar 2017-04-28T14:33:50Z Re: Is there anything wrong with my data model . Help with set expression ! https://community.qlik.com/t5/QlikView/Is-there-anything-wrong-with-my-data-model-Help-with-set/m-p/1335811#M840187 <HTML><HEAD></HEAD><BODY><P>Is there anything in that you cant answer .... <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 28 Apr 2017 14:38:55 GMT https://community.qlik.com/t5/QlikView/Is-there-anything-wrong-with-my-data-model-Help-with-set/m-p/1335811#M840187 shekhar_analyti 2017-04-28T14:38:55Z