topic Re: Value and Total value in the ser in QlikView https://community.qlik.com/t5/QlikView/Value-and-Total-value-in-the-ser/m-p/552695#M1131974 <HTML><HEAD></HEAD><BODY><P>What does the field Rnk represent? Is there a reason you cannot use Sum(TOTAL Cnt) from your table above?&nbsp; But perhaps I am oversimplifying your issue.</P></BODY></HTML> Wed, 20 Nov 2013 19:21:46 GMT 2013-11-20T19:21:46Z Value and Total value in the ser https://community.qlik.com/t5/QlikView/Value-and-Total-value-in-the-ser/m-p/552693#M1131972 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #0000ff; font-size: 8pt;">Hi - I am trying to get % of total goals as additional column. I am trying to get the sum of total count using below expression, but I am not getting the exact total value. Am I missing something here?</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">GOAL_MEM_RNK</SPAN><SPAN style="font-size: 8pt;">={1}, </SPAN><SPAN style="color: #800000; font-size: 8pt;">GOAL_COMP_DT</SPAN><SPAN style="font-size: 8pt;"> ={</SPAN><SPAN style="color: #800000; font-size: 8pt;">"=Len(GOAL_COMP_DT)&gt;0"</SPAN><SPAN style="font-size: 8pt;">} &gt;} {1} </SPAN><SPAN style="color: #800000; font-size: 8pt;">Rnk</SPAN><SPAN style="font-size: 8pt;">)<BR /><BR /> <IMG alt="Untitled.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/49296_Untitled.png" /></SPAN></P><P></P></BODY></HTML> Wed, 20 Nov 2013 19:00:58 GMT https://community.qlik.com/t5/QlikView/Value-and-Total-value-in-the-ser/m-p/552693#M1131972 2013-11-20T19:00:58Z Re: Value and Total value in the ser https://community.qlik.com/t5/QlikView/Value-and-Total-value-in-the-ser/m-p/552694#M1131973 <HTML><HEAD></HEAD><BODY><P>correct expression:&nbsp; SUM<SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">GOAL_MEM_RNK</SPAN><SPAN style="font-size: 8pt;">={1}, </SPAN><SPAN style="color: #800000; font-size: 8pt;">GOAL_COMP_DT</SPAN><SPAN style="font-size: 8pt;"> ={</SPAN><SPAN style="color: #800000; font-size: 8pt;">"=Len(GOAL_COMP_DT)&gt;0"</SPAN><SPAN style="font-size: 8pt;">} &gt;} {1} </SPAN><SPAN style="color: #800000; font-size: 8pt;">Rnk</SPAN><SPAN style="font-size: 8pt;">)</SPAN></P></BODY></HTML> Wed, 20 Nov 2013 19:19:30 GMT https://community.qlik.com/t5/QlikView/Value-and-Total-value-in-the-ser/m-p/552694#M1131973 2013-11-20T19:19:30Z Re: Value and Total value in the ser https://community.qlik.com/t5/QlikView/Value-and-Total-value-in-the-ser/m-p/552695#M1131974 <HTML><HEAD></HEAD><BODY><P>What does the field Rnk represent? Is there a reason you cannot use Sum(TOTAL Cnt) from your table above?&nbsp; But perhaps I am oversimplifying your issue.</P></BODY></HTML> Wed, 20 Nov 2013 19:21:46 GMT https://community.qlik.com/t5/QlikView/Value-and-Total-value-in-the-ser/m-p/552695#M1131974 2013-11-20T19:21:46Z Re: Value and Total value in the ser https://community.qlik.com/t5/QlikView/Value-and-Total-value-in-the-ser/m-p/552696#M1131975 <HTML><HEAD></HEAD><BODY><P>Thanks Rebecca. Adding TOTAL solved this problem..</P></BODY></HTML> Wed, 20 Nov 2013 21:34:35 GMT https://community.qlik.com/t5/QlikView/Value-and-Total-value-in-the-ser/m-p/552696#M1131975 2013-11-20T21:34:35Z