topic Re: How to pivot on an InputField in QlikView https://community.qlik.com/t5/QlikView/How-to-pivot-on-an-InputField/m-p/53149#M8839 <HTML><HEAD></HEAD><BODY><P>Can you upload the qvw file?</P></BODY></HTML> Tue, 06 Feb 2018 01:09:28 GMT Siva_Sankar 2018-02-06T01:09:28Z How to pivot on an InputField https://community.qlik.com/t5/QlikView/How-to-pivot-on-an-InputField/m-p/53147#M8837 <HTML><HEAD></HEAD><BODY><P>I want to use a manual input field to be the pivot point for a pivot table, rather than a field from the database.&nbsp; However each line is being treated as a separate pivot, even though at the moment they all contain exactly the same data. </P><P></P><P>This is what I currently have (all the inputfield entries are C12345):</P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/192508_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>But I want it to look like this:</P><P><IMG alt="" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/192536_pastedImage_2.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>Can somebody help me to get the correct result please?</P><P></P><P>Many thanks</P><P>Mike</P></BODY></HTML> Mon, 05 Feb 2018 14:49:45 GMT https://community.qlik.com/t5/QlikView/How-to-pivot-on-an-InputField/m-p/53147#M8837 Anonymous 2018-02-05T14:49:45Z Re: How to pivot on an InputField https://community.qlik.com/t5/QlikView/How-to-pivot-on-an-InputField/m-p/53148#M8838 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>2 options</P><P></P><P>1- Calculated Dimension :&nbsp; <SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">=</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">Aggr</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">(</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">Dual</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">(Inputfield, RowNo(TOTAL)), Inputfield, </SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">[Ref Series]</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">) </SPAN></P><P><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">2- chart Type = Straight Table</SPAN></P></BODY></HTML> Mon, 05 Feb 2018 22:26:01 GMT https://community.qlik.com/t5/QlikView/How-to-pivot-on-an-InputField/m-p/53148#M8838 el_aprendiz111 2018-02-05T22:26:01Z Re: How to pivot on an InputField https://community.qlik.com/t5/QlikView/How-to-pivot-on-an-InputField/m-p/53149#M8839 <HTML><HEAD></HEAD><BODY><P>Can you upload the qvw file?</P></BODY></HTML> Tue, 06 Feb 2018 01:09:28 GMT https://community.qlik.com/t5/QlikView/How-to-pivot-on-an-InputField/m-p/53149#M8839 Siva_Sankar 2018-02-06T01:09:28Z Re: How to pivot on an InputField https://community.qlik.com/t5/QlikView/How-to-pivot-on-an-InputField/m-p/53150#M8840 <HTML><HEAD></HEAD><BODY><P>Hi Fer Fer</P><P></P><P>Many thanks for your reply.&nbsp; Changing the table to a straight table didn't work, but using =Aggr() worked!</P><P></P><P>Thanks again</P><P>Mike</P></BODY></HTML> Mon, 12 Feb 2018 15:38:04 GMT https://community.qlik.com/t5/QlikView/How-to-pivot-on-an-InputField/m-p/53150#M8840 Anonymous 2018-02-12T15:38:04Z