topic Using variable from input box in expression in QlikView

Using variable from input box in expression

mazacini — Wed, 25 Nov 2020 16:16:04 GMT

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.

Any ideas?

Thanks

Joe

justinvchiang — Wed, 13 Dec 2017 21:58:03 GMT

try adding sum or aggr such as sum(100/$(vMargin)) or aggr(100/$(vMargin), Dim)

mazacini — Wed, 13 Dec 2017 22:09:02 GMT

Thanks Justin

The actual expression I have uses a Set Analysis expression as the numerator, and then the variable as the denominator.

So Sum({<Dim={'ValueA'}>}/(1-$(vMargin))

justinvchiang — Wed, 13 Dec 2017 22:23:32 GMT

I was able to get this to work using sample data if this is what you were going for:

sum({<Dim={'ValueA'}>} fact)/(1-$(vMargin))

mazacini — Wed, 13 Dec 2017 22:49:52 GMT

Thanks Justin

That works fine for me now.

Regards

Joe

justinvchiang — Wed, 13 Dec 2017 22:57:22 GMT

great! Glad it worked