topic Exp Sch in QlikView https://community.qlik.com/t5/QlikView/Exp-Sch/m-p/789318#M279123 <HTML><HEAD></HEAD><BODY><P>Hi friends</P><P></P><P>I have prepared a expenses schedule in pivot table and attached my document also.</P><P></P><P>In my table I have filed "TYPE" where F=Fixed V=Variable&nbsp; S=Semi variable</P><P></P><P>I want to make a calculation of expenditure on the following basis</P><P></P><P>When I select&nbsp; a percentage say 90% I want the amount to be calculated on the following basis</P><P></P><P>All Fixed Item should remain unchanged</P><P>All variable item should change to 90% of the amount</P><P>All semi variable items as per percentage in put by the user</P><P></P><P>Pls help me to make the calculation</P></BODY></HTML> Sat, 06 Dec 2014 09:12:06 GMT upaliwije 2014-12-06T09:12:06Z Exp Sch https://community.qlik.com/t5/QlikView/Exp-Sch/m-p/789318#M279123 <HTML><HEAD></HEAD><BODY><P>Hi friends</P><P></P><P>I have prepared a expenses schedule in pivot table and attached my document also.</P><P></P><P>In my table I have filed "TYPE" where F=Fixed V=Variable&nbsp; S=Semi variable</P><P></P><P>I want to make a calculation of expenditure on the following basis</P><P></P><P>When I select&nbsp; a percentage say 90% I want the amount to be calculated on the following basis</P><P></P><P>All Fixed Item should remain unchanged</P><P>All variable item should change to 90% of the amount</P><P>All semi variable items as per percentage in put by the user</P><P></P><P>Pls help me to make the calculation</P></BODY></HTML> Sat, 06 Dec 2014 09:12:06 GMT https://community.qlik.com/t5/QlikView/Exp-Sch/m-p/789318#M279123 upaliwije 2014-12-06T09:12:06Z Re: Exp Sch https://community.qlik.com/t5/QlikView/Exp-Sch/m-p/789319#M279124 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please see the attached solution.</P><P>Is this what you are looking for?</P><P></P><P>A</P></BODY></HTML> Sat, 06 Dec 2014 10:47:03 GMT https://community.qlik.com/t5/QlikView/Exp-Sch/m-p/789319#M279124 2014-12-06T10:47:03Z