Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, i have a table chart with some dimension.
Is possible to take the value of an dimension ('coefficiente') in an expression in another dimension?
Dimesion
Expression
Thanks
Hi,
what you're trying to do exactly ?
calculating an expression for one value of that dimension ?
Yes, my dimension is COEFFICIENTE, and i want calculate my expression (as you saw in the example) using my dimension
If you want to calculate your measure using your dimension, you should put the dimension in the "dimension" tab, not in the expression tab.
so move COEFFCIENTE to the dimension tab
But COEFFCIENTE is dimension, what you want to calculate?
no sorry, is not that, i have two dimension
1. COEFFICIENTE
2. Punti
i want use this dimension COEFFICIENTE, in the expression of the dimension Punti in this way (this is the expression i have in my dimension Punti):
Sum({<POD = {"=Sum(CONSUMO_TOTALE_KWH)/([coefficiente]*12) < 1000"}>} [coefficiente])
is possible to do that?
Would you be able to share a sample QVW to take a look ?
As per my understand,
This expression using in Dimension, right ??
Sum({<POD = {"=Sum(CONSUMO_TOTALE_KWH)/([coefficiente]*12) < 1000"}>} [coefficiente])
If, i'm right
try this...
Aggr(Sum({<POD = {"=Sum(CONSUMO_TOTALE_KWH)/([coefficiente]*12) < 1000"}>} [coefficiente]), coefficiente)
you mean this ?
Aggr(ONLY({<POD = {"=Sum(CONSUMO_TOTALE_KWH)/([coefficiente]*12) < 1000"}>} [coefficiente]),coefficiente)
I tried this out and actually both are working with a set of data I have..
d.caprelli you can test it and remove your dimensions from the "expression tab"