topic Re: How to split the expression based on some condition? in QlikView https://community.qlik.com/t5/QlikView/How-to-split-the-expression-based-on-some-condition/m-p/1058949#M930682 <HTML><HEAD></HEAD><BODY><P>like this?</P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/117772_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Sat, 12 Mar 2016 13:41:27 GMT Kushal_Chawda 2016-03-12T13:41:27Z How to split the expression based on some condition? https://community.qlik.com/t5/QlikView/How-to-split-the-expression-based-on-some-condition/m-p/1058945#M930678 <HTML><HEAD></HEAD><BODY><P>Dear Experts,</P><P>Our current Chart designed as below.</P><P>Dimension : 12 Customers (X-Axis)</P><P>Expression : Total sales amount for the last 3 years (Y-Axis)</P><P><SPAN style="font-size: 13.3333px;">But our exact requirement is to split the expression by showing 3 individual year total sales for each customer. So that we can see the trend easily.</SPAN></P><P><SPAN style="font-size: 13.3333px;">Kindly advise.</SPAN></P><P><SPAN style="font-size: 13.3333px;">Thanks,</SPAN></P><P><SPAN style="font-size: 13.3333px;">Saravanan<BR /></SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-split-the-expression-based-on-some-condition/m-p/1058945#M930678 2020-11-25T16:16:04Z Re: How to split the expression based on some condition? https://community.qlik.com/t5/QlikView/How-to-split-the-expression-based-on-some-condition/m-p/1058946#M930679 <HTML><HEAD></HEAD><BODY><P><IMG alt="QV_Sales_Report1.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/117764_QV_Sales_Report1.jpg" style="height: 348px; width: 620px;" /></P></BODY></HTML> Sat, 12 Mar 2016 01:32:29 GMT https://community.qlik.com/t5/QlikView/How-to-split-the-expression-based-on-some-condition/m-p/1058946#M930679 2016-03-12T01:32:29Z Re: How to split the expression based on some condition? https://community.qlik.com/t5/QlikView/How-to-split-the-expression-based-on-some-condition/m-p/1058947#M930680 <HTML><HEAD></HEAD><BODY><P>Maybe just use a second dimension <EM>Year</EM> in your chart?</P><P></P><P>And then choose either <EM>stacked</EM> or <EM>grouped</EM> style on style tab?</P></BODY></HTML> Sat, 12 Mar 2016 09:53:40 GMT https://community.qlik.com/t5/QlikView/How-to-split-the-expression-based-on-some-condition/m-p/1058947#M930680 swuehl 2016-03-12T09:53:40Z Re: How to split the expression based on some condition? https://community.qlik.com/t5/QlikView/How-to-split-the-expression-based-on-some-condition/m-p/1058948#M930681 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Make Year as your First Dimension and Customer as second Dimension Like this,</P><P><IMG alt="Chart yearly.PNG" class="jive-image image-1" src="/legacyfs/online/117779_Chart yearly.PNG" style="height: 264px; width: 620px;" /></P><P></P><P>HTH,</P><P>Hirish</P></BODY></HTML> Sat, 12 Mar 2016 13:14:36 GMT https://community.qlik.com/t5/QlikView/How-to-split-the-expression-based-on-some-condition/m-p/1058948#M930681 HirisH_V7 2016-03-12T13:14:36Z Re: How to split the expression based on some condition? https://community.qlik.com/t5/QlikView/How-to-split-the-expression-based-on-some-condition/m-p/1058949#M930682 <HTML><HEAD></HEAD><BODY><P>like this?</P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/117772_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Sat, 12 Mar 2016 13:41:27 GMT https://community.qlik.com/t5/QlikView/How-to-split-the-expression-based-on-some-condition/m-p/1058949#M930682 Kushal_Chawda 2016-03-12T13:41:27Z