Discussion board where members can get started with QlikView.
This is my first post in this community, so i apologise if i am not being crystal clear with what i am going to say.
I have a Pivot Table chart type, in wich i have an expression labeled by "FINAL VAR" defined by this :
Each variable (var1 and var2) comes from diferent tables, and what happens is the following:
For some reason the SUM function used in the expression is not considering the negative value -10071.9 and is giving me the output that you can see.
Please any help or sugestion would be nice.
Do you want to multify ar1 by var2 and then sum
Do you have your qlikview file? The picture might not be enough to solve your problem.
I dont have the qlikview file.
What is suposed to happen is:
I agree with Jacob, it is odd that your expression isn't working. But without your qvw or even your data set it'll be difficult for anyone to help.
perhaps you have some nulls or missing record in the table with var1
example (result is 101)
load * inline [
My guess would be that 10071,9 exists twice in the underlying data!