topic Expressions on Multiple Axes? in QlikView https://community.qlik.com/t5/QlikView/Expressions-on-Multiple-Axes/m-p/376775#M1168950 <HTML><HEAD></HEAD><BODY><P>Dearly beloved QlikCommunity,</P><P></P><P>I'm a QV rookie, currently building out my first ever report. I'm a bit stuck (in something of a Qlikpickle, if you will). </P><P></P><P>I've pasted in an excel drawing to build what I'm envisioning.</P><P></P><TABLE><TBODY><TR><TD><BR /></TD><TD>Yesterday</TD><TD><BR /></TD><TD>Trailing 7 Days</TD><TD><BR /></TD><TD>Trailing 28 Days</TD><TD><BR /></TD><TD>Quarter To Date</TD><TD><BR /></TD><TD>Year To Date</TD><TD><BR /></TD></TR><TR><TD><BR /></TD><TD>#</TD><TD>% of leads</TD><TD>#</TD><TD>% of leads</TD><TD>#</TD><TD>% of leads</TD><TD>#</TD><TD>% of leads</TD><TD>#</TD><TD>% of leads</TD></TR><TR><TD>Total Leads</TD><TD> 534,313</TD><TD>100%</TD><TD> 550,000</TD><TD>100%</TD><TD> 482,212</TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD></TR><TR><TD>Leads Attempted</TD><TD> 480,882</TD><TD>90%</TD><TD> 495,000</TD><TD>90%</TD><TD> 433,991</TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD></TR><TR><TD>Leads Connected</TD><TD> 336,617</TD><TD>63%</TD><TD> 346,500</TD><TD>63%</TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD></TR><TR><TD>Leads Closed</TD><TD> 168,309</TD><TD>32%</TD><TD> 173,250</TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD></TR><TR><TD>so on...</TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD></TR></TBODY></TABLE><P></P><P>I've written the expressions for the relevant metrics, displaying them along the Y-Axis of my report. This works great for the first column, but how does one create multi-column tables showing different time periods?</P><P></P><P>I would think that writing expressions along the X and Y Axes would get me there, but can QV do that? Is there a different way to get there?</P><P></P><P>I'd ideally like to have percentage sub-columns alongside the raw data for each time period (as shown). Can this be done in QV as well?</P></BODY></HTML> Thu, 09 Aug 2012 21:18:59 GMT 2012-08-09T21:18:59Z Expressions on Multiple Axes? https://community.qlik.com/t5/QlikView/Expressions-on-Multiple-Axes/m-p/376775#M1168950 <HTML><HEAD></HEAD><BODY><P>Dearly beloved QlikCommunity,</P><P></P><P>I'm a QV rookie, currently building out my first ever report. I'm a bit stuck (in something of a Qlikpickle, if you will). </P><P></P><P>I've pasted in an excel drawing to build what I'm envisioning.</P><P></P><TABLE><TBODY><TR><TD><BR /></TD><TD>Yesterday</TD><TD><BR /></TD><TD>Trailing 7 Days</TD><TD><BR /></TD><TD>Trailing 28 Days</TD><TD><BR /></TD><TD>Quarter To Date</TD><TD><BR /></TD><TD>Year To Date</TD><TD><BR /></TD></TR><TR><TD><BR /></TD><TD>#</TD><TD>% of leads</TD><TD>#</TD><TD>% of leads</TD><TD>#</TD><TD>% of leads</TD><TD>#</TD><TD>% of leads</TD><TD>#</TD><TD>% of leads</TD></TR><TR><TD>Total Leads</TD><TD> 534,313</TD><TD>100%</TD><TD> 550,000</TD><TD>100%</TD><TD> 482,212</TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD></TR><TR><TD>Leads Attempted</TD><TD> 480,882</TD><TD>90%</TD><TD> 495,000</TD><TD>90%</TD><TD> 433,991</TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD></TR><TR><TD>Leads Connected</TD><TD> 336,617</TD><TD>63%</TD><TD> 346,500</TD><TD>63%</TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD></TR><TR><TD>Leads Closed</TD><TD> 168,309</TD><TD>32%</TD><TD> 173,250</TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD></TR><TR><TD>so on...</TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD></TR></TBODY></TABLE><P></P><P>I've written the expressions for the relevant metrics, displaying them along the Y-Axis of my report. This works great for the first column, but how does one create multi-column tables showing different time periods?</P><P></P><P>I would think that writing expressions along the X and Y Axes would get me there, but can QV do that? Is there a different way to get there?</P><P></P><P>I'd ideally like to have percentage sub-columns alongside the raw data for each time period (as shown). Can this be done in QV as well?</P></BODY></HTML> Thu, 09 Aug 2012 21:18:59 GMT https://community.qlik.com/t5/QlikView/Expressions-on-Multiple-Axes/m-p/376775#M1168950 2012-08-09T21:18:59Z