topic How to write set expression for the below scenario in QlikView https://community.qlik.com/t5/QlikView/How-to-write-set-expression-for-the-below-scenario/m-p/1288022#M403137 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>Below is the sample data(input data) and I want to achieve (expected output).</P><P>Actually I want to do the 'cumulative sum'(running total) of 'hrs' column. and show the data as below.</P><P></P><P>e.g. for 3may team a has woked 20hrs on task 1 and on 4may 20hrs on task1. so for 4th may it should show 40hrs for task 1 by team a.</P><P></P><P>Can anyone suggest something???</P><P></P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/156251_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Tue, 14 Mar 2017 13:59:07 GMT 2017-03-14T13:59:07Z How to write set expression for the below scenario https://community.qlik.com/t5/QlikView/How-to-write-set-expression-for-the-below-scenario/m-p/1288022#M403137 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>Below is the sample data(input data) and I want to achieve (expected output).</P><P>Actually I want to do the 'cumulative sum'(running total) of 'hrs' column. and show the data as below.</P><P></P><P>e.g. for 3may team a has woked 20hrs on task 1 and on 4may 20hrs on task1. so for 4th may it should show 40hrs for task 1 by team a.</P><P></P><P>Can anyone suggest something???</P><P></P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/156251_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Tue, 14 Mar 2017 13:59:07 GMT https://community.qlik.com/t5/QlikView/How-to-write-set-expression-for-the-below-scenario/m-p/1288022#M403137 2017-03-14T13:59:07Z Re: How to write set expression for the below scenario https://community.qlik.com/t5/QlikView/How-to-write-set-expression-for-the-below-scenario/m-p/1288023#M403138 <HTML><HEAD></HEAD><BODY><P>Hi Kulwant,</P><P></P><P>Check please this example,</P><P></P><P>Regards</P><P></P><P>Miguel del Valle de Gracia</P></BODY></HTML> Tue, 14 Mar 2017 16:58:49 GMT https://community.qlik.com/t5/QlikView/How-to-write-set-expression-for-the-below-scenario/m-p/1288023#M403138 migueldelval 2017-03-14T16:58:49Z Re: How to write set expression for the below scenario https://community.qlik.com/t5/QlikView/How-to-write-set-expression-for-the-below-scenario/m-p/1288024#M403139 <HTML><HEAD></HEAD><BODY><P>there is nothing in your qvw. there is only one inline is loaded no charts are there. I wanted to show the output in straight table.</P></BODY></HTML> Tue, 14 Mar 2017 17:19:36 GMT https://community.qlik.com/t5/QlikView/How-to-write-set-expression-for-the-below-scenario/m-p/1288024#M403139 2017-03-14T17:19:36Z Re: How to write set expression for the below scenario https://community.qlik.com/t5/QlikView/How-to-write-set-expression-for-the-below-scenario/m-p/1288025#M403140 <HTML><HEAD></HEAD><BODY><P>Sorry Kulwant,</P><P></P><P>Try it now</P><P></P><P>Regards</P><P></P><P>Miguel del Valle</P></BODY></HTML> Tue, 14 Mar 2017 17:48:40 GMT https://community.qlik.com/t5/QlikView/How-to-write-set-expression-for-the-below-scenario/m-p/1288025#M403140 migueldelval 2017-03-14T17:48:40Z Re: How to write set expression for the below scenario https://community.qlik.com/t5/QlikView/How-to-write-set-expression-for-the-below-scenario/m-p/1288026#M403141 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I want to running sum of the highlighted vales. you are doing it for different task no. I want it for same taskno</P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/156292_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Wed, 15 Mar 2017 03:20:48 GMT https://community.qlik.com/t5/QlikView/How-to-write-set-expression-for-the-below-scenario/m-p/1288026#M403141 2017-03-15T03:20:48Z Re: How to write set expression for the below scenario https://community.qlik.com/t5/QlikView/How-to-write-set-expression-for-the-below-scenario/m-p/1288027#M403142 <HTML><HEAD></HEAD><BODY><P>Hi Kulwant,</P><P></P><P>Try to use Total after Above in set analysis.</P><P></P><P>Regards</P><P></P><P>Miguel del Valle</P></BODY></HTML> Wed, 15 Mar 2017 11:14:13 GMT https://community.qlik.com/t5/QlikView/How-to-write-set-expression-for-the-below-scenario/m-p/1288027#M403142 migueldelval 2017-03-15T11:14:13Z