Issue with pivot table - showing temperatures of two different countries in separate columns

[Anonymous]

Hi all,

I have a - hopefully - very basic question.

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).

I have tried SetAnalysis but this did not work as it always returned only one (same) value in both columns - see below.

Please find sample raw data attached and the result Qlik is giving me.

Can you please help?

Thanks a lot in advance!

Phil

[CM_B]

@Anonymous  Did you ever solve this problem?  I am experiencing the same thing and struggling to resolve - Thanks in advance