topic Re: Monthly Variance Daynamically in QlikView https://community.qlik.com/t5/QlikView/Monthly-Variance-Daynamically/m-p/863529#M532607 <HTML><HEAD></HEAD><BODY><P>add another expression</P><P></P><P>alt(sum(Expenses)-above(Sum(Expenses)),sum(Expenses)) </P><P></P><P><IMG alt="1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/84078_1.png" style="height: 261px; width: 620px;" /></P></BODY></HTML> Sun, 19 Apr 2015 20:25:20 GMT maxgro 2015-04-19T20:25:20Z Monthly Variance Daynamically https://community.qlik.com/t5/QlikView/Monthly-Variance-Daynamically/m-p/863522#M532600 <HTML><HEAD></HEAD><BODY><P><BR />How can i plot the the monthly variance in my chart?</P><P></P><P>I have the cummulative data.</P><P></P><P></P><P>Example:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 192px;"><TBODY><TR><TD height="20" width="64">Year </TD><TD width="64">Month </TD><TD width="64">Sales</TD></TR><TR><TD align="right" height="20">2015</TD><TD>Jan</TD><TD align="right">10</TD></TR><TR><TD align="right" height="20">2015</TD><TD>Feb</TD><TD align="right">40</TD></TR><TR><TD align="right" height="20">2015</TD><TD>Mar</TD><TD align="right">30</TD></TR></TBODY></TABLE><P></P><P>The chart should show the values</P><P></P><P>Jan 10</P><P>Feb 30</P><P>Mar -10</P><P></P><P>The chart show dynamically the month based on availability of data.</P><P></P><P><STRONG>Note</STRONG>: I am using calaender function in my application</P></BODY></HTML> Sun, 19 Apr 2015 10:11:29 GMT https://community.qlik.com/t5/QlikView/Monthly-Variance-Daynamically/m-p/863522#M532600 navaskhan 2015-04-19T10:11:29Z Re: Monthly Variance Daynamically https://community.qlik.com/t5/QlikView/Monthly-Variance-Daynamically/m-p/863523#M532601 <HTML><HEAD></HEAD><BODY><P>my expression is </P><P>alt(sum(Sales)-above(Sum(Sales)),sum(Sales))</P><P><IMG alt="1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/84069_1.png" style="height: auto; width: auto;" /></P></BODY></HTML> Sun, 19 Apr 2015 10:45:08 GMT https://community.qlik.com/t5/QlikView/Monthly-Variance-Daynamically/m-p/863523#M532601 maxgro 2015-04-19T10:45:08Z Re: Monthly Variance Daynamically https://community.qlik.com/t5/QlikView/Monthly-Variance-Daynamically/m-p/863524#M532602 <HTML><HEAD></HEAD><BODY><P>Thank You !</P></BODY></HTML> Sun, 19 Apr 2015 11:19:09 GMT https://community.qlik.com/t5/QlikView/Monthly-Variance-Daynamically/m-p/863524#M532602 navaskhan 2015-04-19T11:19:09Z Re: Monthly Variance Daynamically https://community.qlik.com/t5/QlikView/Monthly-Variance-Daynamically/m-p/863525#M532603 <HTML><HEAD></HEAD><BODY><P>How can i plot this in Trend Chart?</P></BODY></HTML> Sun, 19 Apr 2015 11:44:21 GMT https://community.qlik.com/t5/QlikView/Monthly-Variance-Daynamically/m-p/863525#M532603 navaskhan 2015-04-19T11:44:21Z Re: Monthly Variance Daynamically https://community.qlik.com/t5/QlikView/Monthly-Variance-Daynamically/m-p/863526#M532604 <HTML><HEAD></HEAD><BODY><P>with a calculated dimension and same expression</P><P></P><P><IMG alt="1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/84070_1.png" style="height: auto; width: auto;" /></P></BODY></HTML> Sun, 19 Apr 2015 11:49:18 GMT https://community.qlik.com/t5/QlikView/Monthly-Variance-Daynamically/m-p/863526#M532604 maxgro 2015-04-19T11:49:18Z Re: Monthly Variance Daynamically https://community.qlik.com/t5/QlikView/Monthly-Variance-Daynamically/m-p/863527#M532605 <HTML><HEAD></HEAD><BODY><P>i have another dimension on top of that which shows the actual amount instead of variance when i plot that</P></BODY></HTML> Sun, 19 Apr 2015 12:09:33 GMT https://community.qlik.com/t5/QlikView/Monthly-Variance-Daynamically/m-p/863527#M532605 navaskhan 2015-04-19T12:09:33Z Re: Monthly Variance Daynamically https://community.qlik.com/t5/QlikView/Monthly-Variance-Daynamically/m-p/863528#M532606 <HTML><HEAD></HEAD><BODY><P>My data is lke :</P><P></P><P>Income Jan 200</P><P>Income Feb 250</P><P>Expense Jan 300</P><P>Expense Feb&nbsp; 450</P><P></P><P>The Chart Should show Monthly Income Varince and Expense Variance</P><P></P><P>I.e </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Jan&nbsp;&nbsp;&nbsp; Feb </P><P>Income&nbsp;&nbsp;&nbsp;&nbsp; 200&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50</P><P>Expense&nbsp;&nbsp; 300&nbsp;&nbsp;&nbsp;&nbsp; 150</P></BODY></HTML> Sun, 19 Apr 2015 17:28:00 GMT https://community.qlik.com/t5/QlikView/Monthly-Variance-Daynamically/m-p/863528#M532606 navaskhan 2015-04-19T17:28:00Z Re: Monthly Variance Daynamically https://community.qlik.com/t5/QlikView/Monthly-Variance-Daynamically/m-p/863529#M532607 <HTML><HEAD></HEAD><BODY><P>add another expression</P><P></P><P>alt(sum(Expenses)-above(Sum(Expenses)),sum(Expenses)) </P><P></P><P><IMG alt="1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/84078_1.png" style="height: 261px; width: 620px;" /></P></BODY></HTML> Sun, 19 Apr 2015 20:25:20 GMT https://community.qlik.com/t5/QlikView/Monthly-Variance-Daynamically/m-p/863529#M532607 maxgro 2015-04-19T20:25:20Z Re: Monthly Variance Daynamically https://community.qlik.com/t5/QlikView/Monthly-Variance-Daynamically/m-p/863530#M532608 <HTML><HEAD></HEAD><BODY><P>That works fine . Thanks for your support.</P><P></P><P>How did you hide the Chart Label.</P><P></P><P>i.e when i create the legend the first Ledgend&nbsp; Label is appearing in my chart. How to come out of that?</P></BODY></HTML> Mon, 20 Apr 2015 04:12:31 GMT https://community.qlik.com/t5/QlikView/Monthly-Variance-Daynamically/m-p/863530#M532608 navaskhan 2015-04-20T04:12:31Z Re: Monthly Variance Daynamically https://community.qlik.com/t5/QlikView/Monthly-Variance-Daynamically/m-p/863531#M532609 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Uncheck Show Title in Chart option in </P><P></P><P>Chart Properties -&gt; General tab.</P><P></P><P>Hope this helps you.</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Mon, 20 Apr 2015 05:31:31 GMT https://community.qlik.com/t5/QlikView/Monthly-Variance-Daynamically/m-p/863531#M532609 jagan 2015-04-20T05:31:31Z Re: Monthly Variance Daynamically https://community.qlik.com/t5/QlikView/Monthly-Variance-Daynamically/m-p/863532#M532610 <HTML><HEAD></HEAD><BODY><P>Thanks Jagan.</P><P></P><P>Hot to bring my Legends from Right to Down in Horizontally.</P><P></P><P>Example :</P><P></P><P><STRONG>From :</STRONG></P><P>Income</P><P>Expense</P><P></P><P></P><P><STRONG>To :</STRONG></P><P>Income&nbsp;&nbsp;&nbsp;&nbsp; Expense</P></BODY></HTML> Mon, 20 Apr 2015 05:55:04 GMT https://community.qlik.com/t5/QlikView/Monthly-Variance-Daynamically/m-p/863532#M532610 navaskhan 2015-04-20T05:55:04Z Re: Monthly Variance Daynamically https://community.qlik.com/t5/QlikView/Monthly-Variance-Daynamically/m-p/863533#M532611 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>Check this link</P><P></P><P><A href="https://community.qlik.com/docs/DOC-8235">Horizontal Legend in chart</A></P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Mon, 20 Apr 2015 05:59:40 GMT https://community.qlik.com/t5/QlikView/Monthly-Variance-Daynamically/m-p/863533#M532611 jagan 2015-04-20T05:59:40Z Re: Monthly Variance Daynamically https://community.qlik.com/t5/QlikView/Monthly-Variance-Daynamically/m-p/863534#M532612 <HTML><HEAD></HEAD><BODY><P>shift + ctrl </P><P>then drag the red rectangle to the top/bottom</P></BODY></HTML> Mon, 20 Apr 2015 17:30:18 GMT https://community.qlik.com/t5/QlikView/Monthly-Variance-Daynamically/m-p/863534#M532612 maxgro 2015-04-20T17:30:18Z Re: Monthly Variance Daynamically https://community.qlik.com/t5/QlikView/Monthly-Variance-Daynamically/m-p/863535#M532613 <HTML><HEAD></HEAD><BODY><P>How to forecast the variance for the rest of the months?</P></BODY></HTML> Tue, 28 Apr 2015 13:39:59 GMT https://community.qlik.com/t5/QlikView/Monthly-Variance-Daynamically/m-p/863535#M532613 navaskhan 2015-04-28T13:39:59Z