topic Report format in QlikView

topic Report format in QlikView https://community.qlik.com/t5/QlikView/Report-format/m-p/1936477#M1219176 <H3 class="iw"><SPAN class="qu"><SPAN class="go">Hi Experts,</SPAN></SPAN></H3> <P> </P> <P><SPAN class="qu"><SPAN class="go">I have 11 dimensions: Group , 0-90 Days,90-180 Days.......etc.</SPAN></SPAN></P> <P><SPAN class="qu"><SPAN class="go">I need data in below format. Please guide.</SPAN></SPAN></P> <TABLE width="634"> <TBODY> <TR> <TD colspan="8" width="634">MRO AGING REPORT</TD> </TR> <TR> <TD>Group</TD> <TD>B</TD> <TD>E</TD> <TD>R</TD> <TD>S</TD> <TD>T</TD> <TD>Grand Total</TD> <TD>%</TD> </TR> <TR> <TD>0-90 DAYS</TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> <TR> <TD>91-180 DAYS</TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> <TR> <TD>181-365 DAYS</TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> <TR> <TD>1-2 YRS</TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> <TR> <TD>2-3 yrs</TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> <TR> <TD>3-4 yrs</TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> <TR> <TD>4-5 YRS</TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> <TR> <TD>5-6 YRS</TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> <TR> <TD>6-7 YRS</TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> <TR> <TD>7 YRS & ABOVE</TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> <TR> <TD>Grand Total</TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> <TR> <TD>%</TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> </TBODY> </TABLE> Fri, 27 May 2022 11:03:21 GMT manasvi_naikdhure 2022-05-27T11:03:21Z Report format https://community.qlik.com/t5/QlikView/Report-format/m-p/1936477#M1219176 <H3 class="iw"><SPAN class="qu"><SPAN class="go">Hi Experts,</SPAN></SPAN></H3> <P> </P> <P><SPAN class="qu"><SPAN class="go">I have 11 dimensions: Group , 0-90 Days,90-180 Days.......etc.</SPAN></SPAN></P> <P><SPAN class="qu"><SPAN class="go">I need data in below format. Please guide.</SPAN></SPAN></P> <TABLE width="634"> <TBODY> <TR> <TD colspan="8" width="634">MRO AGING REPORT</TD> </TR> <TR> <TD>Group</TD> <TD>B</TD> <TD>E</TD> <TD>R</TD> <TD>S</TD> <TD>T</TD> <TD>Grand Total</TD> <TD>%</TD> </TR> <TR> <TD>0-90 DAYS</TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> <TR> <TD>91-180 DAYS</TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> <TR> <TD>181-365 DAYS</TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> <TR> <TD>1-2 YRS</TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> <TR> <TD>2-3 yrs</TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> <TR> <TD>3-4 yrs</TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> <TR> <TD>4-5 YRS</TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> <TR> <TD>5-6 YRS</TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> <TR> <TD>6-7 YRS</TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> <TR> <TD>7 YRS & ABOVE</TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> <TR> <TD>Grand Total</TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> <TR> <TD>%</TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> </TBODY> </TABLE> Fri, 27 May 2022 11:03:21 GMT https://community.qlik.com/t5/QlikView/Report-format/m-p/1936477#M1219176 manasvi_naikdhure 2022-05-27T11:03:21Z Re: Report format https://community.qlik.com/t5/QlikView/Report-format/m-p/1936903#M1219193 <P>Refer this </P> <P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/The-Crosstable-Load/ba-p/1468083#:~:text=There%20are%20a%20number%20of,and%20create%20the%20desired%20fields" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/The-Crosstable-Load/ba-p/1468083#:~:text=There%20are%20a%20number%20of,and%20create%20the%20desired%20fields</A>.</P> Sun, 29 May 2022 11:01:46 GMT https://community.qlik.com/t5/QlikView/Report-format/m-p/1936903#M1219193 vinieme12 2022-05-29T11:01:46Z