topic Re: How to do quarter analysis? in QlikView https://community.qlik.com/t5/QlikView/How-to-do-quarter-analysis/m-p/737438#M263729 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Adding Year and Quarter as a Dimension with required expression in bar chart may help you to short out this. See attachment.</P></BODY></HTML> Wed, 09 Jul 2014 04:06:04 GMT Anonymous 2014-07-09T04:06:04Z How to do quarter analysis? https://community.qlik.com/t5/QlikView/How-to-do-quarter-analysis/m-p/737437#M263728 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I got sect of quarters and year, I want to analysis 1Qtr of 2013 VS 1st Qtr 2014 as well as 2nd Qtr of 2013 VS 2nd Qtr 2014</P><P>please go through the attachment and help me out. Thanks! </P></BODY></HTML> Wed, 09 Jul 2014 03:36:27 GMT https://community.qlik.com/t5/QlikView/How-to-do-quarter-analysis/m-p/737437#M263728 2014-07-09T03:36:27Z Re: How to do quarter analysis? https://community.qlik.com/t5/QlikView/How-to-do-quarter-analysis/m-p/737438#M263729 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Adding Year and Quarter as a Dimension with required expression in bar chart may help you to short out this. See attachment.</P></BODY></HTML> Wed, 09 Jul 2014 04:06:04 GMT https://community.qlik.com/t5/QlikView/How-to-do-quarter-analysis/m-p/737438#M263729 Anonymous 2014-07-09T04:06:04Z Re: How to do quarter analysis? https://community.qlik.com/t5/QlikView/How-to-do-quarter-analysis/m-p/737439#M263730 <HTML><HEAD></HEAD><BODY><P>Take 2 dimensions and one expression like bellow..</P><P></P><P>Primary : Quarter</P><P>Secondary : Year</P><P>Expression: Sum(Sales) </P></BODY></HTML> Wed, 09 Jul 2014 05:27:33 GMT https://community.qlik.com/t5/QlikView/How-to-do-quarter-analysis/m-p/737439#M263730 PradeepReddy 2014-07-09T05:27:33Z Re: How to do quarter analysis? https://community.qlik.com/t5/QlikView/How-to-do-quarter-analysis/m-p/737440#M263731 <HTML><HEAD></HEAD><BODY><P>Add two dimensions like Year and Quarter or make single dimension as calculated dimension if required</P><P></P><P>Dim1:-Year</P><P>Dim2:-Quarter</P><P></P><P>Expr:- Sum( YourExpression )</P><P></P><P>Or</P><P></P><P>Dim1:-Year&amp;'-'&amp;<SPAN style="font-size: 10pt; line-height: 1.5em;">Quarter</SPAN></P><P></P><P>Expr:- Sum( YourExpression )</P><P></P><P></P><P>Hope helps you</P></BODY></HTML> Wed, 09 Jul 2014 05:56:13 GMT https://community.qlik.com/t5/QlikView/How-to-do-quarter-analysis/m-p/737440#M263731 its_anandrjs 2014-07-09T05:56:13Z Re: How to do quarter analysis? https://community.qlik.com/t5/QlikView/How-to-do-quarter-analysis/m-p/737441#M263732 <HTML><HEAD></HEAD><BODY><P>Hi Mafaz,</P><P></P><P>PFA Hope it will solve your problem.</P><P></P><P>-- Regards,</P><P>Vishal Waghole</P></BODY></HTML> Wed, 09 Jul 2014 06:15:40 GMT https://community.qlik.com/t5/QlikView/How-to-do-quarter-analysis/m-p/737441#M263732 VishalWaghole 2014-07-09T06:15:40Z Re: How to do quarter analysis? https://community.qlik.com/t5/QlikView/How-to-do-quarter-analysis/m-p/737442#M263733 <HTML><HEAD></HEAD><BODY><P>Hello Mafaz,</P><P></P><P>If in your chart, blue color shows quarter value then other one is showing which value.</P><P></P><P>- Regards,</P><P>Vishal Waghole</P></BODY></HTML> Wed, 09 Jul 2014 06:17:31 GMT https://community.qlik.com/t5/QlikView/How-to-do-quarter-analysis/m-p/737442#M263733 VishalWaghole 2014-07-09T06:17:31Z Re: How to do quarter analysis? https://community.qlik.com/t5/QlikView/How-to-do-quarter-analysis/m-p/737443#M263734 <HTML><HEAD></HEAD><BODY><P>Blue shows - PLAN for Quarter </P><P>PINK - ACTUAL for Quarter </P><P></P><P>but I need it yearly I mean 2013 (PLAN, ACTUAL) VS 2014 (PLAN, ACTUAL)</P></BODY></HTML> Wed, 09 Jul 2014 07:37:35 GMT https://community.qlik.com/t5/QlikView/How-to-do-quarter-analysis/m-p/737443#M263734 2014-07-09T07:37:35Z Re: How to do quarter analysis? https://community.qlik.com/t5/QlikView/How-to-do-quarter-analysis/m-p/737444#M263735 <HTML><HEAD></HEAD><BODY><P>yeah but when if I add more than one expressions bar look like mess coz I have selected 2 dimensions is there any way to show as my attachment?</P></BODY></HTML> Wed, 09 Jul 2014 07:45:35 GMT https://community.qlik.com/t5/QlikView/How-to-do-quarter-analysis/m-p/737444#M263735 2014-07-09T07:45:35Z Re: Re: How to do quarter analysis? https://community.qlik.com/t5/QlikView/How-to-do-quarter-analysis/m-p/737445#M263736 <HTML><HEAD></HEAD><BODY><P>Hi Mafaz,</P><P></P><P>Please refer this file, Hope u want this....</P><P></P><P>-- Regards,</P><P>VIshal Waghole</P></BODY></HTML> Wed, 09 Jul 2014 08:13:35 GMT https://community.qlik.com/t5/QlikView/How-to-do-quarter-analysis/m-p/737445#M263736 VishalWaghole 2014-07-09T08:13:35Z