topic Re: How to fetch value in all rows? in QlikView https://community.qlik.com/t5/QlikView/How-to-fetch-value-in-all-rows/m-p/1369603#M823291 <HTML><HEAD></HEAD><BODY><P>May be use this?</P><P><STRONG>=sum(TOTAL {&lt;Month ={"01"}&gt;} Employee)</STRONG></P></BODY></HTML> Tue, 25 Jul 2017 16:00:54 GMT Anil_Babu_Samineni 2017-07-25T16:00:54Z How to fetch value in all rows? https://community.qlik.com/t5/QlikView/How-to-fetch-value-in-all-rows/m-p/1369602#M823290 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have a straight chart. My first expression is a sum for sales : sum( { &lt; Month={"&lt;=$(=num(Month))"} &gt;&nbsp; }&nbsp;&nbsp; Sales)</P><P>My second exp is the number of employees in january : =sum( {&lt;Month ={"01"}&gt;} Employee)</P><P></P><P>So i have value for employee in january (89) but obviously 0 for the other months. How can i get 89 for all rows?</P><P></P><P>See my attached .qvw sample.</P><P></P><P>Thanks</P><P></P><P> </P><P></P><P><BR /> </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-fetch-value-in-all-rows/m-p/1369602#M823290 sergio0592 2020-11-25T16:16:04Z Re: How to fetch value in all rows? https://community.qlik.com/t5/QlikView/How-to-fetch-value-in-all-rows/m-p/1369603#M823291 <HTML><HEAD></HEAD><BODY><P>May be use this?</P><P><STRONG>=sum(TOTAL {&lt;Month ={"01"}&gt;} Employee)</STRONG></P></BODY></HTML> Tue, 25 Jul 2017 16:00:54 GMT https://community.qlik.com/t5/QlikView/How-to-fetch-value-in-all-rows/m-p/1369603#M823291 Anil_Babu_Samineni 2017-07-25T16:00:54Z