topic Help in QlikView https://community.qlik.com/t5/QlikView/Help/m-p/1246627#M1294018 <HTML><HEAD></HEAD><BODY><P>Dear Team,</P><P></P><P>i stuck a requirement.For this i am sharing Excel.requirement is I want to make a pivot table.</P><P>where dimension is article_code And Fiscal Month.</P><P></P><P>But Expression be set on monthend. Suppose in Sep Month we Have 10 to 20 Dates..But i want t show only Monthend Date Regading Amount on Below Column Sep Month..Same As&nbsp; next month.i want to show amount each month below only monthend value </P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 2</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 3</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 4</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 5</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 6</STRONG></TH></TR><TR><TD style="padding: 2px;">Article_Code</TD><TD style="padding: 2px;">Fiscal Month</TD><TD style="padding: 2px;">Aug</TD><TD style="padding: 2px;">Sep</TD><TD style="padding: 2px;">Oct</TD><TD style="padding: 2px;">Nov</TD></TR><TR><TD style="padding: 2px;">10001</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">100</TD><TD style="padding: 2px;">-</TD><TD style="padding: 2px;">-</TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">10002</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">-</TD><TD style="padding: 2px;">200</TD><TD style="padding: 2px;">-</TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">10003</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">-</TD><TD style="padding: 2px;">-</TD><TD style="padding: 2px;">300</TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT panipat1990 2026-01-26T18:19:17Z Help https://community.qlik.com/t5/QlikView/Help/m-p/1246627#M1294018 <HTML><HEAD></HEAD><BODY><P>Dear Team,</P><P></P><P>i stuck a requirement.For this i am sharing Excel.requirement is I want to make a pivot table.</P><P>where dimension is article_code And Fiscal Month.</P><P></P><P>But Expression be set on monthend. Suppose in Sep Month we Have 10 to 20 Dates..But i want t show only Monthend Date Regading Amount on Below Column Sep Month..Same As&nbsp; next month.i want to show amount each month below only monthend value </P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 2</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 3</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 4</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 5</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 6</STRONG></TH></TR><TR><TD style="padding: 2px;">Article_Code</TD><TD style="padding: 2px;">Fiscal Month</TD><TD style="padding: 2px;">Aug</TD><TD style="padding: 2px;">Sep</TD><TD style="padding: 2px;">Oct</TD><TD style="padding: 2px;">Nov</TD></TR><TR><TD style="padding: 2px;">10001</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">100</TD><TD style="padding: 2px;">-</TD><TD style="padding: 2px;">-</TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">10002</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">-</TD><TD style="padding: 2px;">200</TD><TD style="padding: 2px;">-</TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">10003</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">-</TD><TD style="padding: 2px;">-</TD><TD style="padding: 2px;">300</TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/Help/m-p/1246627#M1294018 panipat1990 2026-01-26T18:19:17Z