topic Re: transpose during load in QlikView https://community.qlik.com/t5/QlikView/transpose-during-load/m-p/1392003#M423121 <HTML><HEAD></HEAD><BODY><P>USER1 is 5? How?</P><P></P><P>May be this</P><P></P><P>If(RangeCount(CourseA, <SPAN style="font-size: 13.3333px;">CourseB, <SPAN style="font-size: 13.3333px;">CourseC, <SPAN style="font-size: 13.3333px;">CourseD, <SPAN style="font-size: 13.3333px;">CourseE, <SPAN style="font-size: 13.3333px;">CourseF, <SPAN style="font-size: 13.3333px;">CourseG) = 0, 1, <SPAN style="font-size: 13.3333px;">RangeCount(CourseA, </SPAN><SPAN style="font-size: 13.3333px;">CourseB, <SPAN style="font-size: 13.3333px;">CourseC, <SPAN style="font-size: 13.3333px;">CourseD, <SPAN style="font-size: 13.3333px;">CourseE, <SPAN style="font-size: 13.3333px;">CourseF, <SPAN style="font-size: 13.3333px;">CourseG))</SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></P></BODY></HTML> Wed, 18 Oct 2017 16:24:35 GMT sunny_talwar 2017-10-18T16:24:35Z transpose during load https://community.qlik.com/t5/QlikView/transpose-during-load/m-p/1392001#M423119 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have the following dataset in excel : </P><P></P><P><IMG alt="sense_transpose.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/180137_sense_transpose.PNG" style="height: 258px; width: 620px;" /></P><P></P><P>What I would like to do is during the load, calculate a total field. Also, where there are no values (eg, row 12) default to 1?</P><P></P><P>Is this possible?</P><P></P><P>Many thanks,</P><P></P><P>Phil</P></BODY></HTML> Wed, 18 Oct 2017 16:20:13 GMT https://community.qlik.com/t5/QlikView/transpose-during-load/m-p/1392001#M423119 prees959 2017-10-18T16:20:13Z Re: transpose during load https://community.qlik.com/t5/QlikView/transpose-during-load/m-p/1392002#M423120 <HTML><HEAD></HEAD><BODY><P>Please share excel file</P></BODY></HTML> Wed, 18 Oct 2017 16:24:21 GMT https://community.qlik.com/t5/QlikView/transpose-during-load/m-p/1392002#M423120 Anil_Babu_Samineni 2017-10-18T16:24:21Z Re: transpose during load https://community.qlik.com/t5/QlikView/transpose-during-load/m-p/1392003#M423121 <HTML><HEAD></HEAD><BODY><P>USER1 is 5? How?</P><P></P><P>May be this</P><P></P><P>If(RangeCount(CourseA, <SPAN style="font-size: 13.3333px;">CourseB, <SPAN style="font-size: 13.3333px;">CourseC, <SPAN style="font-size: 13.3333px;">CourseD, <SPAN style="font-size: 13.3333px;">CourseE, <SPAN style="font-size: 13.3333px;">CourseF, <SPAN style="font-size: 13.3333px;">CourseG) = 0, 1, <SPAN style="font-size: 13.3333px;">RangeCount(CourseA, </SPAN><SPAN style="font-size: 13.3333px;">CourseB, <SPAN style="font-size: 13.3333px;">CourseC, <SPAN style="font-size: 13.3333px;">CourseD, <SPAN style="font-size: 13.3333px;">CourseE, <SPAN style="font-size: 13.3333px;">CourseF, <SPAN style="font-size: 13.3333px;">CourseG))</SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></P></BODY></HTML> Wed, 18 Oct 2017 16:24:35 GMT https://community.qlik.com/t5/QlikView/transpose-during-load/m-p/1392003#M423121 sunny_talwar 2017-10-18T16:24:35Z Re: transpose during load https://community.qlik.com/t5/QlikView/transpose-during-load/m-p/1392004#M423122 <HTML><HEAD></HEAD><BODY><P>You'll want to start with a CrossTable load to unwrap the table.&nbsp; <A href="http://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/ScriptPrefixes/crosstable.htm" title="http://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/ScriptPrefixes/crosstable.htm">Crosstable ‒ QlikView</A></P><P></P><P>-Rob</P></BODY></HTML> Wed, 18 Oct 2017 16:27:42 GMT https://community.qlik.com/t5/QlikView/transpose-during-load/m-p/1392004#M423122 rwunderlich 2017-10-18T16:27:42Z