topic Re: Pivot Table in QlikView https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/1678773#M727366 <P>Did Sunny's post help you get what you needed for your use case?&nbsp; If so, do not forget to return to your thread and on his post, use the Accept as Solution button to mark it giving him credit for the help and letting other Members know that worked.&nbsp; If you did something else, please consider posting that and then mark it to close out the thread, and if you are still working on things, please leave an update with what you still need.</P> <P>Regards,<BR />Brett</P> Mon, 24 Feb 2020 21:48:37 GMT Brett_Bleess 2020-02-24T21:48:37Z Pivot Table https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/1671258#M727363 <TABLE width="506"><TBODY><TR><TD width="120"><STRONG>Region</STRONG></TD><TD width="165"><STRONG>Country</STRONG></TD><TD width="115"><STRONG>Year</STRONG></TD><TD width="106"><STRONG>Month</STRONG></TD></TR><TR><TD>Asia Pacific</TD><TD>Philippines</TD><TD><STRONG>2019</STRONG></TD><TD>Aug</TD></TR><TR><TD>Asia Pacific</TD><TD>Philippines</TD><TD><STRONG>2019</STRONG></TD><TD>Dec</TD></TR><TR><TD>Asia Pacific</TD><TD>Philippines</TD><TD><STRONG>2019</STRONG></TD><TD>Jul</TD></TR><TR><TD>Asia Pacific</TD><TD>Philippines</TD><TD><STRONG>2019</STRONG></TD><TD>Oct</TD></TR><TR><TD>Asia Pacific</TD><TD>Philippines</TD><TD><STRONG>2019</STRONG></TD><TD>Sep</TD></TR><TR><TD>Asia Pacific</TD><TD>Philippines</TD><TD><STRONG>2020</STRONG></TD><TD>Jan</TD></TR><TR><TD>Europe</TD><TD>UK HSBC</TD><TD><STRONG>2019</STRONG></TD><TD>Apr</TD></TR><TR><TD>Europe</TD><TD>UK HSBC</TD><TD><STRONG>2019</STRONG></TD><TD>Aug</TD></TR><TR><TD>Europe</TD><TD>UK HSBC</TD><TD><STRONG>2019</STRONG></TD><TD>Dec</TD></TR><TR><TD>Europe</TD><TD>UK HSBC</TD><TD><STRONG>2019</STRONG></TD><TD>Jul</TD></TR><TR><TD>Europe</TD><TD>UK HSBC</TD><TD><STRONG>2019</STRONG></TD><TD>June</TD></TR><TR><TD>Europe</TD><TD>UK HSBC</TD><TD><STRONG>2019</STRONG></TD><TD>May</TD></TR><TR><TD>Europe</TD><TD>UK HSBC</TD><TD><STRONG>2019</STRONG></TD><TD>Nov</TD></TR><TR><TD>Europe</TD><TD>UK HSBC</TD><TD><STRONG>2019</STRONG></TD><TD>Oct</TD></TR><TR><TD>Europe</TD><TD>UK HSBC</TD><TD><STRONG>2019</STRONG></TD><TD>Sep</TD></TR><TR><TD>Europe</TD><TD>UK HSBC</TD><TD><STRONG>2020</STRONG></TD><TD>Jan</TD></TR><TR><TD>Europe</TD><TD>UK FD</TD><TD><STRONG>2019</STRONG></TD><TD>Aug</TD></TR><TR><TD>Europe</TD><TD>UK FD</TD><TD><STRONG>2019</STRONG></TD><TD>Dec</TD></TR><TR><TD>Europe</TD><TD>UK FD</TD><TD><STRONG>2019</STRONG></TD><TD>Jul</TD></TR><TR><TD>Europe</TD><TD>UK FD</TD><TD><STRONG>2019</STRONG></TD><TD>June</TD></TR><TR><TD>Europe</TD><TD>UK FD</TD><TD><STRONG>2019</STRONG></TD><TD>May</TD></TR><TR><TD>Europe</TD><TD>UK FD</TD><TD><STRONG>2019</STRONG></TD><TD>Nov</TD></TR><TR><TD>Europe</TD><TD>UK FD</TD><TD><STRONG>2019</STRONG></TD><TD>Oct</TD></TR><TR><TD>Europe</TD><TD>UK FD</TD><TD><STRONG>2019</STRONG></TD><TD>Sep</TD></TR><TR><TD>Europe</TD><TD>UK FD</TD><TD><STRONG>2020</STRONG></TD><TD>Jan</TD></TR><TR><TD>Europe</TD><TD>UK MSB</TD><TD><STRONG>2019</STRONG></TD><TD>Aug</TD></TR><TR><TD>Europe</TD><TD>UK MSB</TD><TD><STRONG>2019</STRONG></TD><TD>Jul</TD></TR><TR><TD>Europe</TD><TD>UK MSB</TD><TD><STRONG>2019</STRONG></TD><TD>June</TD></TR><TR><TD>Europe</TD><TD>UK MSB</TD><TD><STRONG>2019</STRONG></TD><TD>Nov</TD></TR><TR><TD>Europe</TD><TD>UK MSB</TD><TD><STRONG>2019</STRONG></TD><TD>Oct</TD></TR><TR><TD>Europe</TD><TD>UK MSB</TD><TD><STRONG>2019</STRONG></TD><TD>Sep</TD></TR><TR><TD>Europe</TD><TD>UK MSB</TD><TD><STRONG>2020</STRONG></TD><TD>Jan</TD></TR><TR><TD>Europe</TD><TD>UK JLFS</TD><TD><STRONG>2019</STRONG></TD><TD>Aug</TD></TR><TR><TD>Europe</TD><TD>UK JLFS</TD><TD><STRONG>2019</STRONG></TD><TD>Jul</TD></TR><TR><TD>Europe</TD><TD>UK JLFS</TD><TD><STRONG>2019</STRONG></TD><TD>Nov</TD></TR><TR><TD>Europe</TD><TD>UK JLFS</TD><TD><STRONG>2019</STRONG></TD><TD>Oct</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I need the&nbsp; table as&nbsp;</P><TABLE width="369"><TBODY><TR><TD width="94"><STRONG>Region</STRONG></TD><TD width="107"><STRONG>Country</STRONG></TD><TD width="168"><STRONG>Min to Max</STRONG></TD></TR><TR><TD>Asia Pacific</TD><TD>Philippines</TD><TD>2019 Jul-2020 Jan</TD></TR><TR><TD>&nbsp; Europe</TD><TD>UK HSBC</TD><TD>2019 Apr-2020 Jan</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P>can anyone please help me on this</P> Sat, 16 Nov 2024 01:22:49 GMT https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/1671258#M727363 qlikapple 2024-11-16T01:22:49Z Re: Pivot Table https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/1671274#M727364 <P>anyone please look into this</P> Fri, 31 Jan 2020 11:48:07 GMT https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/1671274#M727364 qlikapple 2020-01-31T11:48:07Z Re: Pivot Table https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/1671312#M727365 <P>Try this</P><LI-CODE lang="markup">Table: LOAD Region, Country, Date(Min(YearMonth), 'YYYY MMM') &amp; ' - ' &amp; Date(Max(YearMonth), 'YYYY MMM') as [Min to Max] Group By Region, Country; LOAD Region, Country, Year, Month(Date#(Month, 'MMM')) as Month, Date(MakeDate(Year, Month(Date#(Month, 'MMM'))), 'YYYY MMM') as YearMonth; LOAD * INLINE [ Region, Country, Year, Month Asia Pacific, Philippines, 2019, Aug Asia Pacific, Philippines, 2019, Dec Asia Pacific, Philippines, 2019, Jul Asia Pacific, Philippines, 2019, Oct Asia Pacific, Philippines, 2019, Sep Asia Pacific, Philippines, 2020, Jan Europe, UK HSBC, 2019, Apr Europe, UK HSBC, 2019, Aug Europe, UK HSBC, 2019, Dec Europe, UK HSBC, 2019, Jul Europe, UK HSBC, 2019, June Europe, UK HSBC, 2019, May Europe, UK HSBC, 2019, Nov Europe, UK HSBC, 2019, Oct Europe, UK HSBC, 2019, Sep Europe, UK HSBC, 2020, Jan Europe, UK FD, 2019, Aug Europe, UK FD, 2019, Dec Europe, UK FD, 2019, Jul Europe, UK FD, 2019, June Europe, UK FD, 2019, May Europe, UK FD, 2019, Nov Europe, UK FD, 2019, Oct Europe, UK FD, 2019, Sep Europe, UK FD, 2020, Jan Europe, UK MSB, 2019, Aug Europe, UK MSB, 2019, Jul Europe, UK MSB, 2019, June Europe, UK MSB, 2019, Nov Europe, UK MSB, 2019, Oct Europe, UK MSB, 2019, Sep Europe, UK MSB, 2020, Jan Europe, UK JLFS, 2019, Aug Europe, UK JLFS, 2019, Jul Europe, UK JLFS, 2019, Nov Europe, UK JLFS, 2019, Oct ];</LI-CODE> Fri, 31 Jan 2020 13:22:37 GMT https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/1671312#M727365 sunny_talwar 2020-01-31T13:22:37Z Re: Pivot Table https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/1678773#M727366 <P>Did Sunny's post help you get what you needed for your use case?&nbsp; If so, do not forget to return to your thread and on his post, use the Accept as Solution button to mark it giving him credit for the help and letting other Members know that worked.&nbsp; If you did something else, please consider posting that and then mark it to close out the thread, and if you are still working on things, please leave an update with what you still need.</P> <P>Regards,<BR />Brett</P> Mon, 24 Feb 2020 21:48:37 GMT https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/1678773#M727366 Brett_Bleess 2020-02-24T21:48:37Z