topic Re: Is it possible to Create an Expressions with multiple sub-expressions ? in QlikView https://community.qlik.com/t5/QlikView/Is-it-possible-to-Create-an-Expressions-with-multiple-sub/m-p/562988#M482531 <HTML><HEAD></HEAD><BODY><P>Not to worry , i managed to make it work .</P><P></P><P>Basically i wanted the dimension to only return 2 of 4 values .</P></BODY></HTML> Wed, 07 Aug 2013 10:46:45 GMT 2013-08-07T10:46:45Z Is it possible to Create an Expressions with multiple sub-expressions ? https://community.qlik.com/t5/QlikView/Is-it-possible-to-Create-an-Expressions-with-multiple-sub/m-p/562981#M482524 <HTML><HEAD></HEAD><BODY><P>Is it possible to create the below :</P><P></P><P><IMG __jive_id="45105" class="jive-image-thumbnail jive-image" onclick="" alt="Capture.JPG" src="https://community.qlik.com/legacyfs/online/45105_Capture.JPG" width="450" /></P><P></P><P>Basically under the Period Expression we have Sub Expression for Delivery Type .</P><P></P><P>Regards</P><P>TSM</P></BODY></HTML> Wed, 07 Aug 2013 09:11:05 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-Create-an-Expressions-with-multiple-sub/m-p/562981#M482524 2013-08-07T09:11:05Z Re: Is it possible to Create an Expressions with multiple sub-expressions ? https://community.qlik.com/t5/QlikView/Is-it-possible-to-Create-an-Expressions-with-multiple-sub/m-p/562982#M482525 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Yes, its possible by using Pivot table. You can take Customer and MonthYear as dimensions and Type A to D can be the expressions.</P></BODY></HTML> Wed, 07 Aug 2013 09:14:04 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-Create-an-Expressions-with-multiple-sub/m-p/562982#M482525 2013-08-07T09:14:04Z Re: Is it possible to Create an Expressions with multiple sub-expressions ? https://community.qlik.com/t5/QlikView/Is-it-possible-to-Create-an-Expressions-with-multiple-sub/m-p/562983#M482526 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>Thanx for the quick update .</P><P></P><P>Im actually trying to find out if Qlikview allows the Pivoting to be vertical as well ?</P><P>Currently i have the Pivot Table : Year and Customer (Dimensions) and Delivery Type (Expression), as well as the way you suggested but users not happy with this.</P><P></P><P>I guess they to use to Excel .</P></BODY></HTML> Wed, 07 Aug 2013 09:23:14 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-Create-an-Expressions-with-multiple-sub/m-p/562983#M482526 2013-08-07T09:23:14Z Re: Is it possible to Create an Expressions with multiple sub-expressions ? https://community.qlik.com/t5/QlikView/Is-it-possible-to-Create-an-Expressions-with-multiple-sub/m-p/562984#M482527 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Yes, its possible. You just drag the second dimension to top of expressions.</P></BODY></HTML> Wed, 07 Aug 2013 09:26:10 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-Create-an-Expressions-with-multiple-sub/m-p/562984#M482527 2013-08-07T09:26:10Z Re: Is it possible to Create an Expressions with multiple sub-expressions ? https://community.qlik.com/t5/QlikView/Is-it-possible-to-Create-an-Expressions-with-multiple-sub/m-p/562985#M482528 <HTML><HEAD></HEAD><BODY><P>Great That Worked .</P><P></P><P>Is there a way to limit the dimension only to only return 'Delivery type A' and 'Delivery Type C'?</P></BODY></HTML> Wed, 07 Aug 2013 09:42:52 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-Create-an-Expressions-with-multiple-sub/m-p/562985#M482528 2013-08-07T09:42:52Z Re: Is it possible to Create an Expressions with multiple sub-expressions ? https://community.qlik.com/t5/QlikView/Is-it-possible-to-Create-an-Expressions-with-multiple-sub/m-p/562986#M482529 <HTML><HEAD></HEAD><BODY><P>add a calculated dimension</P><P></P><P>if ("nameofyourfield" = 'Delivery Type A ' or "Nameofyourfield" =&nbsp; 'Delivery Type B', "NameOfYourField", null())</P><P></P><P>insert the name of your field wihtout the quotes and should work. </P></BODY></HTML> Wed, 07 Aug 2013 09:48:36 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-Create-an-Expressions-with-multiple-sub/m-p/562986#M482529 2013-08-07T09:48:36Z Re: Is it possible to Create an Expressions with multiple sub-expressions ? https://community.qlik.com/t5/QlikView/Is-it-possible-to-Create-an-Expressions-with-multiple-sub/m-p/562987#M482530 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>From your example, I understand that, Delivery Type A and Delivery Type C are the expressions and Customer &amp; Year are the dimensions. But from here what you are going to limit the dimensions. </P><P></P><P>I am sorry, I could not understand you correctly. Please explain me in detail.</P></BODY></HTML> Wed, 07 Aug 2013 09:53:36 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-Create-an-Expressions-with-multiple-sub/m-p/562987#M482530 2013-08-07T09:53:36Z Re: Is it possible to Create an Expressions with multiple sub-expressions ? https://community.qlik.com/t5/QlikView/Is-it-possible-to-Create-an-Expressions-with-multiple-sub/m-p/562988#M482531 <HTML><HEAD></HEAD><BODY><P>Not to worry , i managed to make it work .</P><P></P><P>Basically i wanted the dimension to only return 2 of 4 values .</P></BODY></HTML> Wed, 07 Aug 2013 10:46:45 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-Create-an-Expressions-with-multiple-sub/m-p/562988#M482531 2013-08-07T10:46:45Z