topic Re: How to give an section access in ranking scenario in QlikView https://community.qlik.com/t5/QlikView/How-to-give-an-section-access-in-ranking-scenario/m-p/112884#M17529 <HTML><HEAD></HEAD><BODY><P>Hi Kumar.</P><P></P><P>As I see, the ranking is showing "1" because your model has "data reduction", therefore the data to rank belongs to the same store only.</P><P></P><P>You can try next:</P><P></P><P>On your load script you could load a second table changing column name related to section access. It will allow you to see information of another stores ("Costcentre" on this example).</P><P></P><P>To see clearly the example, try with different users.</P><P></P><P><A href="https://drive.google.com/file/d/1OZExby_nUlAmAoYm4YS77_FLfiu1kSKt/view?usp=sharing" style="font-size: 13.3333px;" title="https://drive.google.com/file/d/1OZExby_nUlAmAoYm4YS77_FLfiu1kSKt/view?usp=sharing">section access.rar - Google Drive</A></P><P></P><P>I hope it helps you.</P></BODY></HTML> Wed, 22 Aug 2018 21:40:37 GMT isaako34 2018-08-22T21:40:37Z How to give an section access in ranking scenario https://community.qlik.com/t5/QlikView/How-to-give-an-section-access-in-ranking-scenario/m-p/112882#M17527 <HTML><HEAD></HEAD><BODY><P>Dear Experts,</P><P></P><P>We have a ranking for stores. </P><P>Section access has been provided based on the NTNAME(ADID) and Store wise.</P><P>But here the user belongs to one Store. His rank is showing always "1",which is not correct. </P><P>If there is no section access then Ranking is showing correctly.</P><P>May i know how to show the ranking in this case? </P><P></P><P>Thanks in advance. </P></BODY></HTML> Wed, 22 Aug 2018 17:00:31 GMT https://community.qlik.com/t5/QlikView/How-to-give-an-section-access-in-ranking-scenario/m-p/112882#M17527 rkpatelqlikview 2018-08-22T17:00:31Z Re: How to give an section access in ranking scenario https://community.qlik.com/t5/QlikView/How-to-give-an-section-access-in-ranking-scenario/m-p/112883#M17528 <HTML><HEAD></HEAD><BODY><P>Can you share a sample file you are working on?</P></BODY></HTML> Wed, 22 Aug 2018 18:53:41 GMT https://community.qlik.com/t5/QlikView/How-to-give-an-section-access-in-ranking-scenario/m-p/112883#M17528 vishsaggi 2018-08-22T18:53:41Z Re: How to give an section access in ranking scenario https://community.qlik.com/t5/QlikView/How-to-give-an-section-access-in-ranking-scenario/m-p/112884#M17529 <HTML><HEAD></HEAD><BODY><P>Hi Kumar.</P><P></P><P>As I see, the ranking is showing "1" because your model has "data reduction", therefore the data to rank belongs to the same store only.</P><P></P><P>You can try next:</P><P></P><P>On your load script you could load a second table changing column name related to section access. It will allow you to see information of another stores ("Costcentre" on this example).</P><P></P><P>To see clearly the example, try with different users.</P><P></P><P><A href="https://drive.google.com/file/d/1OZExby_nUlAmAoYm4YS77_FLfiu1kSKt/view?usp=sharing" style="font-size: 13.3333px;" title="https://drive.google.com/file/d/1OZExby_nUlAmAoYm4YS77_FLfiu1kSKt/view?usp=sharing">section access.rar - Google Drive</A></P><P></P><P>I hope it helps you.</P></BODY></HTML> Wed, 22 Aug 2018 21:40:37 GMT https://community.qlik.com/t5/QlikView/How-to-give-an-section-access-in-ranking-scenario/m-p/112884#M17529 isaako34 2018-08-22T21:40:37Z