topic Calculation in new method in QlikView https://community.qlik.com/t5/QlikView/Calculation-in-new-method/m-p/166406#M1282831 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>i got one of the requirement from my boss, to get a clear pic i have attached the calculation method in excel for your reference. can any one suggest me how to do this calculation in the Qlik View and develop the reports based on the end results</P><P>Steps:</P><P>1 Table a Shows the actual installation qty</P><P>2 Table b shows that value of the 1st month Qty is shifted to the second month(Qty of Insatallation ) and then accumulation (By Version wise ) of the qty installation is calculated</P><P>3 Table c Shows that the qty of upgrade rate for each month</P><P>For Jan</P><P>Now I need to calculate the target version percentage like this</P><P>V2=sum of V2 Upgrade Qty / No of Installation of V1</P><P>V3= Sum of V3 upgrade Qty / Sum of Installation of V1 and V2</P><P>Note (If you give f2 in the target version tabled you ll find the exact calculation.</P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT Anonymous 2026-01-26T18:19:17Z Calculation in new method https://community.qlik.com/t5/QlikView/Calculation-in-new-method/m-p/166406#M1282831 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>i got one of the requirement from my boss, to get a clear pic i have attached the calculation method in excel for your reference. can any one suggest me how to do this calculation in the Qlik View and develop the reports based on the end results</P><P>Steps:</P><P>1 Table a Shows the actual installation qty</P><P>2 Table b shows that value of the 1st month Qty is shifted to the second month(Qty of Insatallation ) and then accumulation (By Version wise ) of the qty installation is calculated</P><P>3 Table c Shows that the qty of upgrade rate for each month</P><P>For Jan</P><P>Now I need to calculate the target version percentage like this</P><P>V2=sum of V2 Upgrade Qty / No of Installation of V1</P><P>V3= Sum of V3 upgrade Qty / Sum of Installation of V1 and V2</P><P>Note (If you give f2 in the target version tabled you ll find the exact calculation.</P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/Calculation-in-new-method/m-p/166406#M1282831 Anonymous 2026-01-26T18:19:17Z