topic min($(variable)) in QlikView

min($(variable))

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have 4 pricing columns associated to a material

Is it possible to define a field name in a variable, and then use the variable in formulas

vPrice = 1

vSalesPrice = 'SalePrice' & $(vPrice)

in reports,

sum($(vSalesPrice))

which would then return one of the 4 pricing columns, depending on the vPrice variable value?

Currently have 4 separate expressions, using a conditional show based off vPrice, but was hoping to combine to just the one expression

Please advise,

Kind regards,

Rich

sunny_talwar — Wed, 22 Jun 2016 14:03:36 GMT

How about this:

Sum($(='SalePrice' & $(vPrice)))

Wed, 22 Jun 2016 14:10:11 GMT

many thanks Sunny!

effinty2112 — Wed, 22 Jun 2016 14:11:43 GMT

Hi richard,

Have a go with:

=Sum([$(='SalesPrice' & '$(vPrice)')])

the square brackets are not necessary her but would be if you used this with a field name that has a space.

Cheers

Andrew