topic Re: crosstable query in QlikView https://community.qlik.com/t5/QlikView/crosstable-query/m-p/84731#M782022 <HTML><HEAD></HEAD><BODY><P>It's blue in color</P></BODY></HTML> Mon, 26 Mar 2018 17:03:26 GMT shiveshsingh 2018-03-26T17:03:26Z crosstable query https://community.qlik.com/t5/QlikView/crosstable-query/m-p/84725#M782016 <HTML><HEAD></HEAD><BODY><P>i have this data </P><P></P><P> col1&nbsp;&nbsp;&nbsp;&nbsp; col2&nbsp;&nbsp;&nbsp;&nbsp; values </P><P>abc&nbsp;&nbsp;&nbsp;&nbsp; q1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 345</P><P>abc&nbsp;&nbsp;&nbsp;&nbsp; q2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 124</P><P>abc&nbsp;&nbsp;&nbsp;&nbsp; q3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 46</P><P></P><P>i want this like this cross table </P><P></P><P></P><P>abc&nbsp;&nbsp;&nbsp;&nbsp; q1&nbsp;&nbsp;&nbsp; q2&nbsp;&nbsp;&nbsp;&nbsp; q3</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 345 124&nbsp;&nbsp;&nbsp; 46</P><P></P><P></P><P>how i do this ?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/crosstable-query/m-p/84725#M782016 capriconuser 2020-11-25T16:16:04Z Re: crosstable query https://community.qlik.com/t5/QlikView/crosstable-query/m-p/84726#M782017 <HTML><HEAD></HEAD><BODY><P>Create a pivot table with col1 and col2 as dimensions and Sum(values) as an expression/measure. Then pivot the table - click the col2 header and drag the red position indicator to the top until it switches to horizontal.</P></BODY></HTML> Mon, 26 Mar 2018 08:18:04 GMT https://community.qlik.com/t5/QlikView/crosstable-query/m-p/84726#M782017 jonathandienst 2018-03-26T08:18:04Z Re: crosstable query https://community.qlik.com/t5/QlikView/crosstable-query/m-p/84727#M782018 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/197456_Capture.JPG" style="height: auto;" /></P></BODY></HTML> Mon, 26 Mar 2018 08:50:42 GMT https://community.qlik.com/t5/QlikView/crosstable-query/m-p/84727#M782018 shiveshsingh 2018-03-26T08:50:42Z Re: crosstable query https://community.qlik.com/t5/QlikView/crosstable-query/m-p/84728#M782019 <HTML><HEAD></HEAD><BODY><P>a script solution would be:</P><P><A href="https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ScriptPrefixes/Generic.htm" title="https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ScriptPrefixes/Generic.htm">https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ScriptPrefixes/Generic.htm</A></P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Mon, 26 Mar 2018 09:01:06 GMT https://community.qlik.com/t5/QlikView/crosstable-query/m-p/84728#M782019 MarcoWedel 2018-03-26T09:01:06Z Re: crosstable query https://community.qlik.com/t5/QlikView/crosstable-query/m-p/84729#M782020 <HTML><HEAD></HEAD><BODY><P>i treid but this shows nothing and also did not show red position </P></BODY></HTML> Mon, 26 Mar 2018 10:15:43 GMT https://community.qlik.com/t5/QlikView/crosstable-query/m-p/84729#M782020 capriconuser 2018-03-26T10:15:43Z Re: crosstable query https://community.qlik.com/t5/QlikView/crosstable-query/m-p/84730#M782021 <HTML><HEAD></HEAD><BODY><P>Please post a sample</P></BODY></HTML> Mon, 26 Mar 2018 11:29:10 GMT https://community.qlik.com/t5/QlikView/crosstable-query/m-p/84730#M782021 sasiparupudi1 2018-03-26T11:29:10Z Re: crosstable query https://community.qlik.com/t5/QlikView/crosstable-query/m-p/84731#M782022 <HTML><HEAD></HEAD><BODY><P>It's blue in color</P></BODY></HTML> Mon, 26 Mar 2018 17:03:26 GMT https://community.qlik.com/t5/QlikView/crosstable-query/m-p/84731#M782022 shiveshsingh 2018-03-26T17:03:26Z