topic Re: Populate missing sum with necessary values in QlikView https://community.qlik.com/t5/QlikView/Populate-missing-sum-with-necessary-values/m-p/860593#M655023 <HTML><HEAD></HEAD><BODY><P>Have a read of this: <A href="https://community.qlik.com/docs/DOC-3786">Generating Missing Data In QlikView</A></P></BODY></HTML> Fri, 19 Jun 2015 11:00:44 GMT morganaaron 2015-06-19T11:00:44Z Populate missing sum with necessary values https://community.qlik.com/t5/QlikView/Populate-missing-sum-with-necessary-values/m-p/860592#M655022 <HTML><HEAD></HEAD><BODY><P>Good day!</P><P>I have qvd file with fields:</P><P>Revenue with VAT price</P><P><SPAN style="font-size: 13.3333330154419px;">Revenue w/o VAT price</SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">Net revenue price</SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">Net net revenue price</SPAN></P><P><SPAN style="font-size: 13.3333330154419px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">These fields agregated by PricesKey and YearMonth.</SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">For some YearMonth values (</SPAN>Revenue with VAT price,<SPAN style="font-size: 13.3333330154419px;">Revenue w/o VAT price,</SPAN><SPAN style="font-size: 13.3333330154419px;">Net revenue price,</SPAN><SPAN style="font-size: 13.3333330154419px;">Net net revenue price)&nbsp; is null.</SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">In these cases i need get values from nearest previous YearMonths.</SPAN></P><P><SPAN style="font-size: 13.3333330154419px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">Many thanks for help.</SPAN></P><P><SPAN style="font-size: 13.3333330154419px;"><BR /></SPAN></P></BODY></HTML> Fri, 19 Jun 2015 10:41:24 GMT https://community.qlik.com/t5/QlikView/Populate-missing-sum-with-necessary-values/m-p/860592#M655022 Anonymous 2015-06-19T10:41:24Z Re: Populate missing sum with necessary values https://community.qlik.com/t5/QlikView/Populate-missing-sum-with-necessary-values/m-p/860593#M655023 <HTML><HEAD></HEAD><BODY><P>Have a read of this: <A href="https://community.qlik.com/docs/DOC-3786">Generating Missing Data In QlikView</A></P></BODY></HTML> Fri, 19 Jun 2015 11:00:44 GMT https://community.qlik.com/t5/QlikView/Populate-missing-sum-with-necessary-values/m-p/860593#M655023 morganaaron 2015-06-19T11:00:44Z