topic Re: Getting results into the same line in QlikView https://community.qlik.com/t5/QlikView/Getting-results-into-the-same-line/m-p/124778#M509477 <HTML><HEAD></HEAD><BODY><P>May be try using <A href="https://community.qlik.com/docs/DOC-14624">Inter-Record Functions</A> to bring them on the same line. You might need Above/Below based on your sorting.</P></BODY></HTML> Mon, 01 Oct 2018 13:53:18 GMT sunny_talwar 2018-10-01T13:53:18Z Getting results into the same line https://community.qlik.com/t5/QlikView/Getting-results-into-the-same-line/m-p/124777#M509476 <HTML><HEAD></HEAD><BODY><P>Hi, I am using set analysis to produce a table, wherein we want to compare transactions for this year, with the same period last year. My current model does not allow me to show them next to each other - I am only able to show this year's figure in one line, and the previous year below it.</P><P></P><P>How can I get the results aligned?</P><P></P><P>Attached is a screenshot of the table extracted to Excel, I need the green cells to line up in QV?</P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/214812_Capture.JPG" style="height: auto;" /></P><P></P><P></P><P>Thanks so much!</P><P></P><P>Corne</P></BODY></HTML> Mon, 01 Oct 2018 13:51:24 GMT https://community.qlik.com/t5/QlikView/Getting-results-into-the-same-line/m-p/124777#M509476 burgersurfer 2018-10-01T13:51:24Z Re: Getting results into the same line https://community.qlik.com/t5/QlikView/Getting-results-into-the-same-line/m-p/124778#M509477 <HTML><HEAD></HEAD><BODY><P>May be try using <A href="https://community.qlik.com/docs/DOC-14624">Inter-Record Functions</A> to bring them on the same line. You might need Above/Below based on your sorting.</P></BODY></HTML> Mon, 01 Oct 2018 13:53:18 GMT https://community.qlik.com/t5/QlikView/Getting-results-into-the-same-line/m-p/124778#M509477 sunny_talwar 2018-10-01T13:53:18Z Re: Getting results into the same line https://community.qlik.com/t5/QlikView/Getting-results-into-the-same-line/m-p/124779#M509478 <HTML><HEAD></HEAD><BODY><P>You are classifying your data twice. Remove either your dimensions which are specific to a year like UPT 2019 or use one expression for both the year's.</P></BODY></HTML> Mon, 01 Oct 2018 14:02:54 GMT https://community.qlik.com/t5/QlikView/Getting-results-into-the-same-line/m-p/124779#M509478 vamsee 2018-10-01T14:02:54Z