topic Re: custom dismension in QlikView https://community.qlik.com/t5/QlikView/custom-dismension/m-p/971218#M947982 <HTML><HEAD></HEAD><BODY><P>Could be just three expressions put horizontal, with a Year field dimension.</P></BODY></HTML> Tue, 22 Dec 2015 11:36:19 GMT swuehl 2015-12-22T11:36:19Z custom dismension https://community.qlik.com/t5/QlikView/custom-dismension/m-p/971217#M947981 <HTML><HEAD></HEAD><BODY><P>How to create a pivot table with custom dimension like this ?</P><P><IMG alt="Sans titre.png" class="jive-image image-1" src="/legacyfs/online/109682_Sans titre.png" style="height: auto;" /></P></BODY></HTML> Tue, 22 Dec 2015 11:32:09 GMT https://community.qlik.com/t5/QlikView/custom-dismension/m-p/971217#M947981 Anonymous 2015-12-22T11:32:09Z Re: custom dismension https://community.qlik.com/t5/QlikView/custom-dismension/m-p/971218#M947982 <HTML><HEAD></HEAD><BODY><P>Could be just three expressions put horizontal, with a Year field dimension.</P></BODY></HTML> Tue, 22 Dec 2015 11:36:19 GMT https://community.qlik.com/t5/QlikView/custom-dismension/m-p/971218#M947982 swuehl 2015-12-22T11:36:19Z Re: custom dismension https://community.qlik.com/t5/QlikView/custom-dismension/m-p/971219#M947983 <HTML><HEAD></HEAD><BODY><OL class="dp-sql" start="1"><LI>NewTable:&nbsp; </LI><LI><SPAN class="keyword">LOAD * INLINE [&nbsp; </SPAN></LI><LI>&nbsp;&nbsp;&nbsp; Header1, Header2, Header3&nbsp; </LI><LI>&nbsp;&nbsp;&nbsp; delivered, ,&nbsp; </LI><LI>&nbsp;&nbsp;&nbsp; opened, ,&nbsp; </LI><LI>&nbsp;&nbsp;&nbsp; landing_page_hits, ,&nbsp; </LI><LI>&nbsp;&nbsp;&nbsp; sign_up, ,&nbsp; </LI><LI>&nbsp;&nbsp;&nbsp; completions, ,&nbsp; </LI><LI>];&nbsp; </LI></OL><P>likj dis</P><P></P><P>or else try <STRONG>cross table</STRONG></P></BODY></HTML> Tue, 22 Dec 2015 11:37:31 GMT https://community.qlik.com/t5/QlikView/custom-dismension/m-p/971219#M947983 Chanty4u 2015-12-22T11:37:31Z Re: custom dismension https://community.qlik.com/t5/QlikView/custom-dismension/m-p/971220#M947984 <HTML><HEAD></HEAD><BODY><P>You can use ValueList() function: <A href="http://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/ChartFunctions/SyntheticDimensionFunctions/valuelist.htm?q=valuelist" title="http://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/ChartFunctions/SyntheticDimensionFunctions/valuelist.htm?q=valuelist">QlikView ‒ ValueList - chart function</A></P></BODY></HTML> Tue, 22 Dec 2015 11:38:25 GMT https://community.qlik.com/t5/QlikView/custom-dismension/m-p/971220#M947984 sunny_talwar 2015-12-22T11:38:25Z Re: custom dismension https://community.qlik.com/t5/QlikView/custom-dismension/m-p/971221#M947985 <HTML><HEAD></HEAD><BODY><P>Year as dimension....</P><P></P><P>3 Expressions : each point to a specific client.</P><P></P><P>Then drag to make year field horizontal.</P></BODY></HTML> Tue, 22 Dec 2015 11:56:52 GMT https://community.qlik.com/t5/QlikView/custom-dismension/m-p/971221#M947985 2015-12-22T11:56:52Z