topic Re: using a variable in a calculated dimension in QlikView

using a variable in a calculated dimension

Mon, 26 Oct 2015 16:05:26 GMT

I have an expression stored in a vriable that I would like to use as a claulted dimension. I am having issues getting the variable to work as a calculated dimesnion (have followed other threads on the topic and followed the syntax)

since my calcualted expression has multiple results (calculting price/ton) I would also like to somehow group the results as well

I know the expression is correct because I am using it in other charts, with the correct results

Re: using a variable in a calculated dimension

sinanozdemir — Mon, 26 Oct 2015 16:07:27 GMT

Are you using it within an Aggr() function in your calculated dimension? Maybe an example you can post.

Re: using a variable in a calculated dimension

marcus_sommer — Mon, 26 Oct 2015 16:07:41 GMT

Maybe you are missing an aggr() to wrap your expression - an example of your calculated dimension would be helpful.

- Marcus

Re: using a variable in a calculated dimension

Mon, 26 Oct 2015 16:18:45 GMT

my variable is actuall the total of 3 other variables -

$(vFreightPerTon) + $(vMaterialPerTon) + $(vOtherPerTon)

the variable is vTotalperTon

Re: using a variable in a calculated dimension

marcus_sommer — Mon, 26 Oct 2015 16:21:29 GMT

This won't work - have a look here what is needed for a calculated dimension: Calculated Dimensions.

- Marcus

Re: using a variable in a calculated dimension

Mon, 26 Oct 2015 17:03:15 GMT

Marcus

thanks for the info and insight