topic Show Top 3 Based on First Dimension in QlikView https://community.qlik.com/t5/QlikView/Show-Top-3-Based-on-First-Dimension/m-p/1229851#M391964 <HTML><HEAD></HEAD><BODY><P>Hi Guys,</P><P></P><P>I am trying to get the Top 3 based on First Dimension.</P><P></P><P>The Required Result based on Example I want to find top 3 pages with there top 3 specialty in either pivot table or as the sample output but not in straight table.</P><P></P><P>Attached is the example with required output.</P><P></P><P>Thanks,</P><P>Piyush</P></BODY></HTML> Sat, 04 Mar 2017 09:08:40 GMT 2017-03-04T09:08:40Z Show Top 3 Based on First Dimension https://community.qlik.com/t5/QlikView/Show-Top-3-Based-on-First-Dimension/m-p/1229851#M391964 <HTML><HEAD></HEAD><BODY><P>Hi Guys,</P><P></P><P>I am trying to get the Top 3 based on First Dimension.</P><P></P><P>The Required Result based on Example I want to find top 3 pages with there top 3 specialty in either pivot table or as the sample output but not in straight table.</P><P></P><P>Attached is the example with required output.</P><P></P><P>Thanks,</P><P>Piyush</P></BODY></HTML> Sat, 04 Mar 2017 09:08:40 GMT https://community.qlik.com/t5/QlikView/Show-Top-3-Based-on-First-Dimension/m-p/1229851#M391964 2017-03-04T09:08:40Z Re: Show Top 3 Based on First Dimension https://community.qlik.com/t5/QlikView/Show-Top-3-Based-on-First-Dimension/m-p/1229852#M391965 <HTML><HEAD></HEAD><BODY><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/155237_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Sat, 04 Mar 2017 10:00:28 GMT https://community.qlik.com/t5/QlikView/Show-Top-3-Based-on-First-Dimension/m-p/1229852#M391965 Anonymous 2017-03-04T10:00:28Z Re: Show Top 3 Based on First Dimension https://community.qlik.com/t5/QlikView/Show-Top-3-Based-on-First-Dimension/m-p/1229853#M391966 <HTML><HEAD></HEAD><BODY><P>Hi Robin,</P><P></P><P>Thanks for quick reply.</P><P></P><P>Can we use Sum(Value) instead of -Value.</P><P></P><P>Thanks,</P><P>Piyush</P></BODY></HTML> Sat, 04 Mar 2017 10:12:20 GMT https://community.qlik.com/t5/QlikView/Show-Top-3-Based-on-First-Dimension/m-p/1229853#M391966 2017-03-04T10:12:20Z Re: Show Top 3 Based on First Dimension https://community.qlik.com/t5/QlikView/Show-Top-3-Based-on-First-Dimension/m-p/1229854#M391967 <HTML><HEAD></HEAD><BODY><P>like that?:</P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/155227_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Sat, 04 Mar 2017 10:23:16 GMT https://community.qlik.com/t5/QlikView/Show-Top-3-Based-on-First-Dimension/m-p/1229854#M391967 Anonymous 2017-03-04T10:23:16Z Re: Show Top 3 Based on First Dimension https://community.qlik.com/t5/QlikView/Show-Top-3-Based-on-First-Dimension/m-p/1229855#M391968 <HTML><HEAD></HEAD><BODY><P>Thanks Robin. It worked..</P><P></P><P>Thanks,</P><P>Piyush</P></BODY></HTML> Sat, 04 Mar 2017 11:30:43 GMT https://community.qlik.com/t5/QlikView/Show-Top-3-Based-on-First-Dimension/m-p/1229855#M391968 2017-03-04T11:30:43Z