topic Re: Getting all months gwrth value in QlikView https://community.qlik.com/t5/QlikView/Getting-all-months-gwrth-value/m-p/1347558#M414555 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/docs/DOC-2380">Qlik Community Tip: How to Get Answers to Your Post</A></P><P><A href="https://community.qlik.com/docs/DOC-7538">Qlik Community Tip: Posting Successful Discussion Threads</A></P><P><A href="https://community.qlik.com/docs/DOC-14806">Qlik Community Tip: Marking Replies as Correct or Helpful</A></P></BODY></HTML> Tue, 02 May 2017 06:10:14 GMT MK_QSL 2017-05-02T06:10:14Z Getting all months gwrth value https://community.qlik.com/t5/QlikView/Getting-all-months-gwrth-value/m-p/1347552#M414549 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Can anyone look here ,</P><P></P><P>I am getting all months with grwth 100% ...</P><P></P><P>Grwth Expression : ((Column(1)-column(2))/fabs(column(2))) *100</P><P></P><P></P><P></P><P>coming output :</P><P></P><P><IMG __jive_id="161825" alt="Grwth.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/161825_Grwth.png" style="height: 224px; width: 620px;" /></P></BODY></HTML> Tue, 02 May 2017 05:17:27 GMT https://community.qlik.com/t5/QlikView/Getting-all-months-gwrth-value/m-p/1347552#M414549 prma7799 2017-05-02T05:17:27Z Re: Getting all months gwrth value https://community.qlik.com/t5/QlikView/Getting-all-months-gwrth-value/m-p/1347553#M414550 <HTML><HEAD></HEAD><BODY><P>If you don't have data For Column 1 and 2 then Qlik consider as 0 so then it will introduce 100% only. If not, You may provide more information <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 02 May 2017 05:31:56 GMT https://community.qlik.com/t5/QlikView/Getting-all-months-gwrth-value/m-p/1347553#M414550 Anil_Babu_Samineni 2017-05-02T05:31:56Z Re: Getting all months gwrth value https://community.qlik.com/t5/QlikView/Getting-all-months-gwrth-value/m-p/1347554#M414551 <HTML><HEAD></HEAD><BODY><P>But in another chart it is showing only Apr data how it is possible then .</P><P></P><P>Is there any settings need to change in front end?</P><P></P><P>Please see the attached </P></BODY></HTML> Tue, 02 May 2017 05:35:15 GMT https://community.qlik.com/t5/QlikView/Getting-all-months-gwrth-value/m-p/1347554#M414551 prma7799 2017-05-02T05:35:15Z Re: Getting all months gwrth value https://community.qlik.com/t5/QlikView/Getting-all-months-gwrth-value/m-p/1347555#M414552 <HTML><HEAD></HEAD><BODY><P>Yes, Go to dimension tab and Select month and give Suppress When value is null </P></BODY></HTML> Tue, 02 May 2017 05:37:21 GMT https://community.qlik.com/t5/QlikView/Getting-all-months-gwrth-value/m-p/1347555#M414552 Anil_Babu_Samineni 2017-05-02T05:37:21Z Re: Getting all months gwrth value https://community.qlik.com/t5/QlikView/Getting-all-months-gwrth-value/m-p/1347556#M414553 <HTML><HEAD></HEAD><BODY><P>I tried ...</P><P></P><P>But same gets appeared ...</P></BODY></HTML> Tue, 02 May 2017 05:40:11 GMT https://community.qlik.com/t5/QlikView/Getting-all-months-gwrth-value/m-p/1347556#M414553 prma7799 2017-05-02T05:40:11Z Re: Getting all months gwrth value https://community.qlik.com/t5/QlikView/Getting-all-months-gwrth-value/m-p/1347557#M414554 <HTML><HEAD></HEAD><BODY><P>How values are looking when you use this? <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>((Column(1)-column(2))/fabs(column(2)))</STRONG></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG><BR /></STRONG></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Can you provide sample<STRONG><BR /></STRONG></SPAN></P></BODY></HTML> Tue, 02 May 2017 05:49:00 GMT https://community.qlik.com/t5/QlikView/Getting-all-months-gwrth-value/m-p/1347557#M414554 Anil_Babu_Samineni 2017-05-02T05:49:00Z Re: Getting all months gwrth value https://community.qlik.com/t5/QlikView/Getting-all-months-gwrth-value/m-p/1347558#M414555 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/docs/DOC-2380">Qlik Community Tip: How to Get Answers to Your Post</A></P><P><A href="https://community.qlik.com/docs/DOC-7538">Qlik Community Tip: Posting Successful Discussion Threads</A></P><P><A href="https://community.qlik.com/docs/DOC-14806">Qlik Community Tip: Marking Replies as Correct or Helpful</A></P></BODY></HTML> Tue, 02 May 2017 06:10:14 GMT https://community.qlik.com/t5/QlikView/Getting-all-months-gwrth-value/m-p/1347558#M414555 MK_QSL 2017-05-02T06:10:14Z