topic Re: Issue with pivot table - showing temperatures of two different countries in separate columns in QlikView https://community.qlik.com/t5/QlikView/Issue-with-pivot-table-showing-temperatures-of-two-different/m-p/1569359#M600799 <P>@Anonymous&nbsp; Did you ever solve this problem?&nbsp; I am experiencing the same thing and struggling to resolve - Thanks in advance</P> Mon, 15 Apr 2019 11:41:50 GMT CM_B 2019-04-15T11:41:50Z Issue with pivot table - showing temperatures of two different countries in separate columns https://community.qlik.com/t5/QlikView/Issue-with-pivot-table-showing-temperatures-of-two-different/m-p/113162#M600798 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have a - hopefully - very basic question.</P><P>I'm currently trying to create a pivot table that shows different temperature values across the year for two different countries in two separate columns. The temperature values are monthly averages (not related to a specific year - see attached). </P><P>I have tried SetAnalysis but this did not work as it always returned only one (same) value in both columns - see below. </P><P></P><P><IMG alt="issue.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/214541_issue.jpg" style="height: 370px; width: 620px;" /></P><P></P><P>Please find sample raw data attached and the result Qlik is giving me. </P><P></P><P>Can you please help? </P><P></P><P>Thanks a lot in advance! </P><P>Phil</P><P></P><TABLE border="1" class="jiveBorder" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY></TBODY></TABLE></BODY></HTML> Wed, 26 Sep 2018 20:39:03 GMT https://community.qlik.com/t5/QlikView/Issue-with-pivot-table-showing-temperatures-of-two-different/m-p/113162#M600798 Anonymous 2018-09-26T20:39:03Z Re: Issue with pivot table - showing temperatures of two different countries in separate columns https://community.qlik.com/t5/QlikView/Issue-with-pivot-table-showing-temperatures-of-two-different/m-p/1569359#M600799 <P>@Anonymous&nbsp; Did you ever solve this problem?&nbsp; I am experiencing the same thing and struggling to resolve - Thanks in advance</P> Mon, 15 Apr 2019 11:41:50 GMT https://community.qlik.com/t5/QlikView/Issue-with-pivot-table-showing-temperatures-of-two-different/m-p/1569359#M600799 CM_B 2019-04-15T11:41:50Z