topic Re: Matrix For Pivot Expressions in QlikView https://community.qlik.com/t5/QlikView/Matrix-For-Pivot-Expressions/m-p/440315#M1162960 <HTML><HEAD></HEAD><BODY><P>can u elaborate with some sample file/data/picture ?</P></BODY></HTML> Sun, 16 Dec 2012 08:59:11 GMT 2012-12-16T08:59:11Z Matrix For Pivot Expressions https://community.qlik.com/t5/QlikView/Matrix-For-Pivot-Expressions/m-p/440314#M1162959 <HTML><HEAD></HEAD><BODY><P dir="ltr" style="text-align: left; background: whitesmoke;"><SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">Hi all,</SPAN><SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;"><BR /><SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">Is there a way</SPAN> <SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">to make group from expressions?</SPAN><SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;"><BR /><SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">I mean</SPAN><SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">, I have exp.1 exp.2 and exp.3</SPAN><SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">,</SPAN><SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;"><BR /><SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">I want to</SPAN> <SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">create a</SPAN> <SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">dimension</SPAN> <SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">if</SPAN> <SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">it</SPAN> <SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">is closed</SPAN> <SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">it will show</SPAN> <SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">the sum of</SPAN> <SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">exp</SPAN> <SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">1</SPAN> <SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">and exp 2.</SPAN><SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">, </SPAN><SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">exp</SPAN> <SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">3 will stand alone</SPAN><SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;"><BR /><SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">If it</SPAN> <SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">will be open</SPAN> <SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">the title</SPAN> <SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">will be the</SPAN> <SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">sum</SPAN> <SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">and</SPAN> <SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">exp.</SPAN> <SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">3</SPAN> <SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">. the Sub title</SPAN> <SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">will be </SPAN> <SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">exp</SPAN> <SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">1 and</SPAN> <SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">exp</SPAN> <SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">2 and</SPAN> <SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">exp</SPAN> <SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">3</SPAN></SPAN></SPAN></SPAN></SPAN></P><P dir="rtl"></P><P dir="rtl">Thanks, </P><P dir="rtl">Ester</P></BODY></HTML> Sun, 16 Dec 2012 07:57:10 GMT https://community.qlik.com/t5/QlikView/Matrix-For-Pivot-Expressions/m-p/440314#M1162959 ester_pr 2012-12-16T07:57:10Z Re: Matrix For Pivot Expressions https://community.qlik.com/t5/QlikView/Matrix-For-Pivot-Expressions/m-p/440315#M1162960 <HTML><HEAD></HEAD><BODY><P>can u elaborate with some sample file/data/picture ?</P></BODY></HTML> Sun, 16 Dec 2012 08:59:11 GMT https://community.qlik.com/t5/QlikView/Matrix-For-Pivot-Expressions/m-p/440315#M1162960 2012-12-16T08:59:11Z Re: Matrix For Pivot Expressions https://community.qlik.com/t5/QlikView/Matrix-For-Pivot-Expressions/m-p/440316#M1162961 <HTML><HEAD></HEAD><BODY><P><IMG __jive_id="26908" class="jive-image" alt="exm.JPG" src="https://community.qlik.com/legacyfs/online/26908_exm.JPG" /></P></BODY></HTML> Sun, 16 Dec 2012 09:09:23 GMT https://community.qlik.com/t5/QlikView/Matrix-For-Pivot-Expressions/m-p/440316#M1162961 ester_pr 2012-12-16T09:09:23Z Re: Matrix For Pivot Expressions https://community.qlik.com/t5/QlikView/Matrix-For-Pivot-Expressions/m-p/440317#M1162963 <HTML><HEAD></HEAD><BODY><P>With an option of pivot</P><P>Thanks,</P><P>Ester</P></BODY></HTML> Sun, 16 Dec 2012 09:10:58 GMT https://community.qlik.com/t5/QlikView/Matrix-For-Pivot-Expressions/m-p/440317#M1162963 ester_pr 2012-12-16T09:10:58Z Re: Matrix For Pivot Expressions https://community.qlik.com/t5/QlikView/Matrix-For-Pivot-Expressions/m-p/440318#M1162964 <HTML><HEAD></HEAD><BODY><P>i think u've in ur mind what u need....but sorry i dnt understand much from this</P><P></P><P>Probably u need something like cyclic expressions but there u can see one expression at a time.</P><P></P><P></P><P>Regards</P></BODY></HTML> Sun, 16 Dec 2012 16:12:29 GMT https://community.qlik.com/t5/QlikView/Matrix-For-Pivot-Expressions/m-p/440318#M1162964 2012-12-16T16:12:29Z Re: Matrix For Pivot Expressions https://community.qlik.com/t5/QlikView/Matrix-For-Pivot-Expressions/m-p/440319#M1162965 <HTML><HEAD></HEAD><BODY><P>no, not that ,i need 2 expressions to see them apart , and in one sum if opening pivot</P><P>Thanks,</P><P>Ester</P></BODY></HTML> Mon, 17 Dec 2012 06:29:19 GMT https://community.qlik.com/t5/QlikView/Matrix-For-Pivot-Expressions/m-p/440319#M1162965 ester_pr 2012-12-17T06:29:19Z