Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
geogou1973
Creator
Creator

Problem with variables and sum in different groups

Hello.

I'm facing a problem. I have data like accounts and debits. Also i have groups like income, margin e.t.c and accounts.

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.

Some accounts are the same for Income and Margin.

Can anyone knows when i change a variable to change also the debits in income group and margin group because of the same accounts?

I attached a sample QVW.

Thank you in advance.

4 Replies
MK_QSL
MVP
MVP

Probably you have used '=' while declaring variables... Don't use = sign

Cost_Var

SUM({<GROUP = {'Cost'}>}DEBIT)

Margin_Var

SUM({<GROUP = {'Margin'}>}DEBIT)


etc

geogou1973
Creator
Creator
Author

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 ?

MK_QSL
MVP
MVP

Not understood your requirement properly. Could you please elaborate in brief?

geogou1973
Creator
Creator
Author

If you see in the attached file i have sent i have some variables. Also some accounts are same for income and margin.

How can i calculate with giving manually a number in the variable the same accounts in income and margin in the level of group ?