topic Re: Odd behaviour with data association in QlikView https://community.qlik.com/t5/QlikView/Odd-behaviour-with-data-association/m-p/417210#M155126 <HTML><HEAD></HEAD><BODY><P>i have faced same issue and now i got solution.. In the sort tab check Expression box and write Expression is just = sign..It works..</P></BODY></HTML> Tue, 12 Feb 2013 17:26:26 GMT 2013-02-12T17:26:26Z Odd behaviour with data association https://community.qlik.com/t5/QlikView/Odd-behaviour-with-data-association/m-p/417204#M155120 <HTML><HEAD></HEAD><BODY><P>Hello QV Community</P><P></P><P>I have loaded up two columns from a single stored QVD.&nbsp; I'll call them field 1 and field 2.</P><P></P><P>In a small number of cases, when i select a value in field 1, no associated value appears in field 2 (selections greyed out suggesting there is no data association.)</P><P></P><P>However, i know that this is not true!&nbsp; When I sort field 2 in ascending order, rather than auto ascending, the correct associated value is displayed.</P><P></P><P>I find this quite odd!&nbsp; Can anybody explain why this may be happening?</P><P></P><P>Thanks in advance</P><P></P><P>Rich</P></BODY></HTML> Thu, 07 Feb 2013 19:12:46 GMT https://community.qlik.com/t5/QlikView/Odd-behaviour-with-data-association/m-p/417204#M155120 2013-02-07T19:12:46Z Re: Odd behaviour with data association https://community.qlik.com/t5/QlikView/Odd-behaviour-with-data-association/m-p/417205#M155121 <HTML><HEAD></HEAD><BODY><P>I have also Experience same..</P></BODY></HTML> Thu, 07 Feb 2013 20:23:15 GMT https://community.qlik.com/t5/QlikView/Odd-behaviour-with-data-association/m-p/417205#M155121 2013-02-07T20:23:15Z Re: Odd behaviour with data association https://community.qlik.com/t5/QlikView/Odd-behaviour-with-data-association/m-p/417206#M155122 <HTML><HEAD></HEAD><BODY><P>Do you have a sample file you can upload?</P></BODY></HTML> Thu, 07 Feb 2013 20:23:36 GMT https://community.qlik.com/t5/QlikView/Odd-behaviour-with-data-association/m-p/417206#M155122 2013-02-07T20:23:36Z Re: Odd behaviour with data association https://community.qlik.com/t5/QlikView/Odd-behaviour-with-data-association/m-p/417207#M155123 <HTML><HEAD></HEAD><BODY><P>Hi Rebecca.</P><P></P><P>Please see the attached qvd.&nbsp; When I load this into a Qlikview document and select 12233651 in Field 1, Field 3 suggests there is no associated data.</P><P></P><P>If i change the sort from Auto Ascending to Ascending in the properties of Field 3, then I see that value 31 is valid for the selection I have made in Field 1.</P><P></P><P>For info we are using QV10 Service Release 5.</P><P></P><P>Thanks</P></BODY></HTML> Thu, 07 Feb 2013 21:23:03 GMT https://community.qlik.com/t5/QlikView/Odd-behaviour-with-data-association/m-p/417207#M155123 2013-02-07T21:23:03Z Re: Odd behaviour with data association https://community.qlik.com/t5/QlikView/Odd-behaviour-with-data-association/m-p/417208#M155124 <HTML><HEAD></HEAD><BODY><P>When I select 12233651 I show 31 for Field 3 and the sort isn't messing anything up.&nbsp; I am using V11 though, so maybe it is something in your version.&nbsp; Sorry I don't have anything else to offer you!!</P></BODY></HTML> Thu, 07 Feb 2013 21:33:54 GMT https://community.qlik.com/t5/QlikView/Odd-behaviour-with-data-association/m-p/417208#M155124 2013-02-07T21:33:54Z Re: Odd behaviour with data association https://community.qlik.com/t5/QlikView/Odd-behaviour-with-data-association/m-p/417209#M155125 <HTML><HEAD></HEAD><BODY><P>OK.&nbsp; Perhaps it's time to organise an upgrade to 11 !</P><P></P><P>Thanks all the same for taking a look.</P></BODY></HTML> Thu, 07 Feb 2013 22:31:57 GMT https://community.qlik.com/t5/QlikView/Odd-behaviour-with-data-association/m-p/417209#M155125 2013-02-07T22:31:57Z Re: Odd behaviour with data association https://community.qlik.com/t5/QlikView/Odd-behaviour-with-data-association/m-p/417210#M155126 <HTML><HEAD></HEAD><BODY><P>i have faced same issue and now i got solution.. In the sort tab check Expression box and write Expression is just = sign..It works..</P></BODY></HTML> Tue, 12 Feb 2013 17:26:26 GMT https://community.qlik.com/t5/QlikView/Odd-behaviour-with-data-association/m-p/417210#M155126 2013-02-12T17:26:26Z Re: Odd behaviour with data association https://community.qlik.com/t5/QlikView/Odd-behaviour-with-data-association/m-p/417211#M155127 <HTML><HEAD></HEAD><BODY><P>Thanks for the info.&nbsp; The problem is intermittent so I believe must be a bug in my version.&nbsp; But I will try your approach next time I see it happening!</P></BODY></HTML> Wed, 13 Feb 2013 09:59:31 GMT https://community.qlik.com/t5/QlikView/Odd-behaviour-with-data-association/m-p/417211#M155127 2013-02-13T09:59:31Z