topic Re: Set Analysis for Outstanding Monthly Trend in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-for-Outstanding-Monthly-Trend/m-p/418584#M488182 <HTML><HEAD></HEAD><BODY><P>Adity,</P><P>so why dont go with Pie chart if possible</P></BODY></HTML> Mon, 14 Jan 2013 07:15:46 GMT sujeetsingh 2013-01-14T07:15:46Z Set Analysis for Outstanding Monthly Trend https://community.qlik.com/t5/QlikView/Set-Analysis-for-Outstanding-Monthly-Trend/m-p/418581#M488179 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a calculations to calculate Outstanding value based on invoice and payment transactions from each month. With this calculations i can get an outstanding value just for selected Month. My problem is, i cant show it as Outstanding trend in chart, I want to show it as an outstanding monthly trend but what i get is a accumulations.</P><P>Please check attached file.</P><P>Thank you</P></BODY></HTML> Mon, 14 Jan 2013 05:46:32 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-for-Outstanding-Monthly-Trend/m-p/418581#M488179 2013-01-14T05:46:32Z Re: Set Analysis for Outstanding Monthly Trend https://community.qlik.com/t5/QlikView/Set-Analysis-for-Outstanding-Monthly-Trend/m-p/418582#M488180 <HTML><HEAD></HEAD><BODY><P>Please explain what you want in chart....</P><P>is it that you want the chart trend for selected month (day wise or week wise) or something else</P></BODY></HTML> Mon, 14 Jan 2013 06:37:38 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-for-Outstanding-Monthly-Trend/m-p/418582#M488180 sujeetsingh 2013-01-14T06:37:38Z Re: Set Analysis for Outstanding Monthly Trend https://community.qlik.com/t5/QlikView/Set-Analysis-for-Outstanding-Monthly-Trend/m-p/418583#M488181 <HTML><HEAD></HEAD><BODY><P>Yes..it is a chart trend for selected month with abbility to day also.</P><P>Example:</P><P>Outstanding for</P><P>2012 Okt = 100.000</P><P>2012 Sep = 120.000</P><P>2012 Aug = 90.000</P><P>2012 Jul = 80.000</P><P></P><P>Assume i have 2 charts</P><P>1. Gauge chart, to show outstanding value for selected month.</P><P>2. Line Chart, to show outstanding trend in month year</P><P></P><P>if i selected on Sep 2012, my chart will shown</P><P>Gauge chart: 120.000</P><P>Line Chart</P><P>2012 Sep : 120.000</P><P>2012 Aug : 90.000</P><P>2012 Jul : 80.000</P><P></P><P>current conditions, my line chart is not showing like above but showing the accumulation for outstanding 2012 Sep.</P></BODY></HTML> Mon, 14 Jan 2013 06:57:19 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-for-Outstanding-Monthly-Trend/m-p/418583#M488181 2013-01-14T06:57:19Z Re: Set Analysis for Outstanding Monthly Trend https://community.qlik.com/t5/QlikView/Set-Analysis-for-Outstanding-Monthly-Trend/m-p/418584#M488182 <HTML><HEAD></HEAD><BODY><P>Adity,</P><P>so why dont go with Pie chart if possible</P></BODY></HTML> Mon, 14 Jan 2013 07:15:46 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-for-Outstanding-Monthly-Trend/m-p/418584#M488182 sujeetsingh 2013-01-14T07:15:46Z Re: Set Analysis for Outstanding Monthly Trend https://community.qlik.com/t5/QlikView/Set-Analysis-for-Outstanding-Monthly-Trend/m-p/418585#M488183 <HTML><HEAD></HEAD><BODY><P>thats not the solutions. I want to have trend, not comparisson.</P></BODY></HTML> Mon, 14 Jan 2013 07:34:16 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-for-Outstanding-Monthly-Trend/m-p/418585#M488183 2013-01-14T07:34:16Z Re: Set Analysis for Outstanding Monthly Trend https://community.qlik.com/t5/QlikView/Set-Analysis-for-Outstanding-Monthly-Trend/m-p/418586#M488184 <HTML><HEAD></HEAD><BODY><P>any solutions?</P></BODY></HTML> Wed, 16 Jan 2013 00:30:51 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-for-Outstanding-Monthly-Trend/m-p/418586#M488184 2013-01-16T00:30:51Z