I am very new to Qlikview and have a question about using variables in chart expressions. I have a formula that I would like to store in a variable. The reason for wanting to store in a variable is that the formula is going to be used in MANY charts within my application, and I would like to maintain the formula in one spot....in case it needs to change. Here's the formula:
=
Sum(REG_HOURS_NUM + OVERTIME_HOURS_NUM)
I'm placing the formula in a variable called vTest. I then create an expression in my chart as $(vTest). The formula calculates a number, but seems to be unaware of dimensionality in the chart. I have a dimension in my chart for the day of the month, I get the same number, which appears to be just a grand total, for each record in my straight table.
Any help/suggestions would be greatly appreciated.
