topic Re: Re: Need Help?? in QlikView https://community.qlik.com/t5/QlikView/Need-Help/m-p/679331#M1086378 <HTML><HEAD></HEAD><BODY><P>Hi Swuehl,</P><P></P><P>PFA,</P><P></P><P>when i am click Quarter it's not showing data..</P><P>Please once check...</P></BODY></HTML> Sat, 14 Jun 2014 14:57:13 GMT paulwalker 2014-06-14T14:57:13Z Need Help?? https://community.qlik.com/t5/QlikView/Need-Help/m-p/679329#M1086376 <HTML><HEAD></HEAD><BODY><P>Hi Community,</P><P></P><P>I have Quarter dimension and Qty Measure.</P><P>i want calculate Quarter on Quarter growth in Sales..</P><P></P><P>Thanks in Advance.........</P></BODY></HTML> Sat, 14 Jun 2014 14:28:21 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/679329#M1086376 paulwalker 2014-06-14T14:28:21Z Re: Need Help?? https://community.qlik.com/t5/QlikView/Need-Help/m-p/679330#M1086377 <HTML><HEAD></HEAD><BODY><P>You can use chart inter record functions like above():</P><P></P><P>Create a straight table with dimension Quarter, then an expression</P><P></P><P>=sum(Qty)</P><P></P><P>and for the change</P><P>=sum(Qty)/above(sum(Qty))-1</P></BODY></HTML> Sat, 14 Jun 2014 14:40:27 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/679330#M1086377 swuehl 2014-06-14T14:40:27Z Re: Re: Need Help?? https://community.qlik.com/t5/QlikView/Need-Help/m-p/679331#M1086378 <HTML><HEAD></HEAD><BODY><P>Hi Swuehl,</P><P></P><P>PFA,</P><P></P><P>when i am click Quarter it's not showing data..</P><P>Please once check...</P></BODY></HTML> Sat, 14 Jun 2014 14:57:13 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/679331#M1086378 paulwalker 2014-06-14T14:57:13Z Re: Need Help?? https://community.qlik.com/t5/QlikView/Need-Help/m-p/679332#M1086379 <HTML><HEAD></HEAD><BODY><P>The document failed to open on my system. Any security / section access applied?</P><P></P><P>And please try to reduce your data a little.</P></BODY></HTML> Sat, 14 Jun 2014 15:18:17 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/679332#M1086379 swuehl 2014-06-14T15:18:17Z Re: Re: Need Help?? https://community.qlik.com/t5/QlikView/Need-Help/m-p/679333#M1086380 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>Please try it once..</P></BODY></HTML> Sat, 14 Jun 2014 15:26:10 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/679333#M1086380 paulwalker 2014-06-14T15:26:10Z Re: Re: Need Help?? https://community.qlik.com/t5/QlikView/Need-Help/m-p/679334#M1086381 <HTML><HEAD></HEAD><BODY><P>Hi Swuehl,</P><P></P><P>Please Once you see correct or not..</P></BODY></HTML> Sat, 14 Jun 2014 16:33:15 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/679334#M1086381 paulwalker 2014-06-14T16:33:15Z Re: Re: Re: Need Help?? https://community.qlik.com/t5/QlikView/Need-Help/m-p/679335#M1086382 <HTML><HEAD></HEAD><BODY><P>I have an idea, but this would require your Quarter being in chronological load order.</P><P></P><P>Attaching a modified load script that should do this. Please reload and re-upload.</P></BODY></HTML> Sat, 14 Jun 2014 16:40:00 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/679335#M1086382 swuehl 2014-06-14T16:40:00Z Re: Re: Re: Re: Need Help?? https://community.qlik.com/t5/QlikView/Need-Help/m-p/679336#M1086383 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>PFA</P></BODY></HTML> Sat, 14 Jun 2014 17:09:59 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/679336#M1086383 paulwalker 2014-06-14T17:09:59Z Re: Re: Re: Re: Re: Need Help?? https://community.qlik.com/t5/QlikView/Need-Help/m-p/679337#M1086384 <HTML><HEAD></HEAD><BODY><P>Maybe like this?</P></BODY></HTML> Sat, 14 Jun 2014 17:32:16 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/679337#M1086384 swuehl 2014-06-14T17:32:16Z Re: Re: Re: Re: Need Help?? https://community.qlik.com/t5/QlikView/Need-Help/m-p/679338#M1086385 <HTML><HEAD></HEAD><BODY><P>Exactly, </P><P></P><P>Thank you Swuehl.......</P></BODY></HTML> Sat, 14 Jun 2014 17:38:12 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/679338#M1086385 paulwalker 2014-06-14T17:38:12Z Re: Re: Re: Re: Need Help?? https://community.qlik.com/t5/QlikView/Need-Help/m-p/679339#M1086386 <HTML><HEAD></HEAD><BODY><P>But small prob, I have Q1 data also..</P><P>but here it's not showing....</P><P>Once you take Qty in listbox, </P></BODY></HTML> Sat, 14 Jun 2014 17:49:15 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/679339#M1086386 paulwalker 2014-06-14T17:49:15Z Re: Re: Re: Re: Re: Need Help?? https://community.qlik.com/t5/QlikView/Need-Help/m-p/679340#M1086387 <HTML><HEAD></HEAD><BODY><P>Yes, you have data for Q1. And I also noticed, your data spans two years.</P><P></P><P>If you aggregate your data on Quarter basis across all available years, there is no preceding Quarter for the first quarter to calculate the percentage change (like in a list box, there is no Quarter above Q1).</P><P></P><P>If you want to consider the Quarter on a year basis, then you could include in the advanced aggregation dimension list and maybe average the change percentage across years.</P><P></P><P>Not sure if you understand what I am trying to say, maybe the attached updated version helps.</P></BODY></HTML> Sat, 14 Jun 2014 18:18:50 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/679340#M1086387 swuehl 2014-06-14T18:18:50Z