topic Re: Combining straight tables in QlikView https://community.qlik.com/t5/QlikView/Combining-straight-tables/m-p/1386832#M422225 <HTML><HEAD></HEAD><BODY><P>PFA</P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/184990_Capture.JPG" style="max-width: 620px; height: auto;" /></P></BODY></HTML> Wed, 29 Nov 2017 02:03:42 GMT Anil_Babu_Samineni 2017-11-29T02:03:42Z Combining straight tables https://community.qlik.com/t5/QlikView/Combining-straight-tables/m-p/1386827#M422220 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have the below 5 similar straight tables with different dimensions but exact same expressions, but I want to combine them. This is because it's a hassle to maintain and do column sorts (need to sort column 5 times for example). Is this possible in Qlikview?</P><P></P><P></P><P><IMG __jive_id="184900" alt="Screenshot for QV Community.png" class="jive-image image-1" src="/legacyfs/online/184900_Screenshot for QV Community.png" style="height: auto;" /></P></BODY></HTML> Tue, 28 Nov 2017 11:29:55 GMT https://community.qlik.com/t5/QlikView/Combining-straight-tables/m-p/1386827#M422220 sifatnabil 2017-11-28T11:29:55Z Re: Combining straight tables https://community.qlik.com/t5/QlikView/Combining-straight-tables/m-p/1386828#M422221 <HTML><HEAD></HEAD><BODY><P>May be possible, Please share sample application to work ..</P></BODY></HTML> Tue, 28 Nov 2017 11:32:54 GMT https://community.qlik.com/t5/QlikView/Combining-straight-tables/m-p/1386828#M422221 Anil_Babu_Samineni 2017-11-28T11:32:54Z Re: Combining straight tables https://community.qlik.com/t5/QlikView/Combining-straight-tables/m-p/1386829#M422222 <HTML><HEAD></HEAD><BODY><P>Hi, please see attached.</P></BODY></HTML> Tue, 28 Nov 2017 11:40:27 GMT https://community.qlik.com/t5/QlikView/Combining-straight-tables/m-p/1386829#M422222 sifatnabil 2017-11-28T11:40:27Z Re: Combining straight tables https://community.qlik.com/t5/QlikView/Combining-straight-tables/m-p/1386830#M422223 <HTML><HEAD></HEAD><BODY><P>Just build a pivot table With 4 Dimension and one Expression</P></BODY></HTML> Tue, 28 Nov 2017 12:04:46 GMT https://community.qlik.com/t5/QlikView/Combining-straight-tables/m-p/1386830#M422223 stabben23 2017-11-28T12:04:46Z Re: Combining straight tables https://community.qlik.com/t5/QlikView/Combining-straight-tables/m-p/1386831#M422224 <HTML><HEAD></HEAD><BODY><P>Hi, building a pivot will place dimensions horizontally like below. I'm trying to get the dimensions to be on top of each other like in my original post.</P><P><IMG alt="Screenshot for QV Community 2.png" class="jive-image image-1" src="/legacyfs/online/184908_Screenshot for QV Community 2.png" style="font-size: 13.3333px;" /></P></BODY></HTML> Tue, 28 Nov 2017 12:09:06 GMT https://community.qlik.com/t5/QlikView/Combining-straight-tables/m-p/1386831#M422224 sifatnabil 2017-11-28T12:09:06Z Re: Combining straight tables https://community.qlik.com/t5/QlikView/Combining-straight-tables/m-p/1386832#M422225 <HTML><HEAD></HEAD><BODY><P>PFA</P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/184990_Capture.JPG" style="max-width: 620px; height: auto;" /></P></BODY></HTML> Wed, 29 Nov 2017 02:03:42 GMT https://community.qlik.com/t5/QlikView/Combining-straight-tables/m-p/1386832#M422225 Anil_Babu_Samineni 2017-11-29T02:03:42Z Re: Combining straight tables https://community.qlik.com/t5/QlikView/Combining-straight-tables/m-p/1386833#M422226 <HTML><HEAD></HEAD><BODY><P>I think a simple expression like this should work here... don't need to repeat the same expression multiple times</P><P><STRONG>Sum(Revenue)</STRONG></P></BODY></HTML> Wed, 29 Nov 2017 04:47:28 GMT https://community.qlik.com/t5/QlikView/Combining-straight-tables/m-p/1386833#M422226 sunny_talwar 2017-11-29T04:47:28Z Re: Combining straight tables https://community.qlik.com/t5/QlikView/Combining-straight-tables/m-p/1386834#M422227 <HTML><HEAD></HEAD><BODY><P>Thanks - Is there a way to bring in the dimension names in the table? e.g. </P><P>Brand</P><P>..</P><P>..</P><P>Product</P><P>..</P><P>..</P></BODY></HTML> Wed, 29 Nov 2017 08:57:02 GMT https://community.qlik.com/t5/QlikView/Combining-straight-tables/m-p/1386834#M422227 sifatnabil 2017-11-29T08:57:02Z Re: Combining straight tables https://community.qlik.com/t5/QlikView/Combining-straight-tables/m-p/1386835#M422228 <HTML><HEAD></HEAD><BODY><P>Check attached</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/185074_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 29 Nov 2017 13:35:25 GMT https://community.qlik.com/t5/QlikView/Combining-straight-tables/m-p/1386835#M422228 sunny_talwar 2017-11-29T13:35:25Z Re: Combining straight tables https://community.qlik.com/t5/QlikView/Combining-straight-tables/m-p/1386836#M422229 <HTML><HEAD></HEAD><BODY><P>Hi <A href="https://community.qlik.com/qlik-users/171708">stalwar1</A>‌, This is great - is it possible to sort the expression column by numeric descending? I'm not able to sort the expression column at all. Thanks.</P></BODY></HTML> Wed, 29 Nov 2017 17:42:48 GMT https://community.qlik.com/t5/QlikView/Combining-straight-tables/m-p/1386836#M422229 sifatnabil 2017-11-29T17:42:48Z Re: Combining straight tables https://community.qlik.com/t5/QlikView/Combining-straight-tables/m-p/1386837#M422230 <HTML><HEAD></HEAD><BODY><P>So within each dimension, you want it to be sorted by numerically descending order?</P></BODY></HTML> Wed, 29 Nov 2017 19:10:02 GMT https://community.qlik.com/t5/QlikView/Combining-straight-tables/m-p/1386837#M422230 sunny_talwar 2017-11-29T19:10:02Z Re: Combining straight tables https://community.qlik.com/t5/QlikView/Combining-straight-tables/m-p/1386838#M422231 <HTML><HEAD></HEAD><BODY><P>Yes.</P></BODY></HTML> Wed, 29 Nov 2017 19:10:58 GMT https://community.qlik.com/t5/QlikView/Combining-straight-tables/m-p/1386838#M422231 sifatnabil 2017-11-29T19:10:58Z Re: Combining straight tables https://community.qlik.com/t5/QlikView/Combining-straight-tables/m-p/1386839#M422232 <HTML><HEAD></HEAD><BODY><P>Sort using this</P><P><STRONG>=RangeSum(Dim, -Sum(Revenue)/1E10)</STRONG></P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/185143_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 29 Nov 2017 19:11:53 GMT https://community.qlik.com/t5/QlikView/Combining-straight-tables/m-p/1386839#M422232 sunny_talwar 2017-11-29T19:11:53Z Re: Combining straight tables https://community.qlik.com/t5/QlikView/Combining-straight-tables/m-p/1386840#M422233 <HTML><HEAD></HEAD><BODY><P>Amazing!</P></BODY></HTML> Wed, 29 Nov 2017 19:15:11 GMT https://community.qlik.com/t5/QlikView/Combining-straight-tables/m-p/1386840#M422233 sifatnabil 2017-11-29T19:15:11Z