topic Re: Problem with variables and sum in different groups in QlikView https://community.qlik.com/t5/QlikView/Problem-with-variables-and-sum-in-different-groups/m-p/989618#M337344 <HTML><HEAD></HEAD><BODY><P>Not understood your requirement properly. Could you please elaborate in brief?</P></BODY></HTML> Mon, 07 Sep 2015 13:45:35 GMT MK_QSL 2015-09-07T13:45:35Z Problem with variables and sum in different groups https://community.qlik.com/t5/QlikView/Problem-with-variables-and-sum-in-different-groups/m-p/989615#M337341 <HTML><HEAD></HEAD><BODY><P>Hello.</P><P></P><P>I'm facing a problem. I have data like accounts and debits. Also i have groups like income, margin e.t.c and accounts.</P><P>i summarized in a pivot chart the debit. Also i have created variables for each group and in the chart i calculate the new value of debit according the value in the variable you give. So far everything is working correct.</P><P>Some accounts are the same for Income and Margin.</P><P>Can anyone knows when i change a variable to change also the debits in income group and margin group because of the same accounts?</P><P></P><P>I attached a sample QVW.</P><P></P><P>Thank you in advance. </P></BODY></HTML> Mon, 07 Sep 2015 12:57:49 GMT https://community.qlik.com/t5/QlikView/Problem-with-variables-and-sum-in-different-groups/m-p/989615#M337341 geogou1973 2015-09-07T12:57:49Z Re: Problem with variables and sum in different groups https://community.qlik.com/t5/QlikView/Problem-with-variables-and-sum-in-different-groups/m-p/989616#M337342 <HTML><HEAD></HEAD><BODY><P>Probably you have used '=' while declaring variables... Don't use = sign</P><P>Cost_Var</P><P>SUM({&lt;GROUP = {'Cost'}&gt;}DEBIT)</P><P></P><P>Margin_Var</P><P><SPAN style="font-size: 13.3333px;">SUM({&lt;GROUP = {'Margin'}&gt;}DEBIT)</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">etc<BR /></SPAN></P></BODY></HTML> Mon, 07 Sep 2015 13:29:26 GMT https://community.qlik.com/t5/QlikView/Problem-with-variables-and-sum-in-different-groups/m-p/989616#M337342 MK_QSL 2015-09-07T13:29:26Z Re: Problem with variables and sum in different groups https://community.qlik.com/t5/QlikView/Problem-with-variables-and-sum-in-different-groups/m-p/989617#M337343 <HTML><HEAD></HEAD><BODY><P>I want to give manually the percent in an input box and effects by calculating also the income and margin because of the some same accounts they have. Can i do this and with which way ?</P></BODY></HTML> Mon, 07 Sep 2015 13:37:36 GMT https://community.qlik.com/t5/QlikView/Problem-with-variables-and-sum-in-different-groups/m-p/989617#M337343 geogou1973 2015-09-07T13:37:36Z Re: Problem with variables and sum in different groups https://community.qlik.com/t5/QlikView/Problem-with-variables-and-sum-in-different-groups/m-p/989618#M337344 <HTML><HEAD></HEAD><BODY><P>Not understood your requirement properly. Could you please elaborate in brief?</P></BODY></HTML> Mon, 07 Sep 2015 13:45:35 GMT https://community.qlik.com/t5/QlikView/Problem-with-variables-and-sum-in-different-groups/m-p/989618#M337344 MK_QSL 2015-09-07T13:45:35Z Re: Problem with variables and sum in different groups https://community.qlik.com/t5/QlikView/Problem-with-variables-and-sum-in-different-groups/m-p/989619#M337345 <HTML><HEAD></HEAD><BODY><P>If you see in the attached file i have sent i have some variables. Also some accounts are same for income and margin.</P><P>How can i calculate with giving manually a number in the variable the same accounts in income and margin in the level of group ?</P></BODY></HTML> Mon, 07 Sep 2015 13:57:39 GMT https://community.qlik.com/t5/QlikView/Problem-with-variables-and-sum-in-different-groups/m-p/989619#M337345 geogou1973 2015-09-07T13:57:39Z