Discussion board where members can get started with QlikView.
I have an input box where I pick values from a list for variable vMargin.
I now want to use this variable in a simple expression in a chart, I'm getting a null value.
If i just use the expression =$(vMargin), I get the value of variable as picked in the input box.
However, when I add another element to the margin, even a constant e.g. 100/$(vMargin), I'm getting a null value.
Go to Solution.
I was able to get this to work using sample data if this is what you were going for:
try adding sum or aggr such as sum(100/$(vMargin)) or aggr(100/$(vMargin), Dim)
The actual expression I have uses a Set Analysis expression as the numerator, and then the variable as the denominator.
That works fine for me now.
great! Glad it worked