Discussion Board for collaboration on QlikView Publisher.
I have a question.
now I have three tables.
1) 'product' and 'price' definition
2) The table which can count through variables in input box
3) Last is Result.
I know that top of the last table was appeared, but I want to use that total value again.
To do that, I thought I need one variable more and want to show that value(=variable) in text box no action.
I don't how to explain that variable in expression.
want to show [RESULT=3000].
WHY,I used other variable value in text box. but didn't appear value. impossible?
Go to Solution.
Not sure if I understand you correctly.
Per my understanding you want to display the total of "Result" column.
You can have the total shown in the same table :
Go to Properties-expressions of the table, then in total mode section, check any of the radio button to display the total in the table itself.
Now, to get the total displayed in a text box, you can set a variable as Sum(Your Expression) in Variable overview and then use that variable in text box.
PFA. hope it helps.
thank you again
I sorry already solve it before see your answer.
thank you so much every time
after checking sum in expression tab,
so I tried to use your answer again '=$(vResult)'
but that's not working
I don't know reason exactly.....
my variable name is vI
I used it '= num(sum ($(vI)), '#,##0')'
Its working well..