topic Re: Take value from dimension in expression in QlikView

Take value from dimension in expression

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

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

Re: Take value from dimension in expression

YoussefBelloum — Wed, 21 Mar 2018 09:19:38 GMT

Hi,

what you're trying to do exactly ?

calculating an expression for one value of that dimension ?

Re: Take value from dimension in expression

danosoft — Wed, 21 Mar 2018 09:23:28 GMT

Yes, my dimension is COEFFICIENTE, and i want calculate my expression (as you saw in the example) using my dimension

Re: Take value from dimension in expression

YoussefBelloum — Wed, 21 Mar 2018 09:48:33 GMT

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

Re: Take value from dimension in expression

shiveshsingh — Wed, 21 Mar 2018 10:03:47 GMT

But COEFFCIENTE is dimension, what you want to calculate?

Re: Take value from dimension in expression

danosoft — Wed, 21 Mar 2018 10:25:58 GMT

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?

Re: Take value from dimension in expression

YoussefBelloum — Wed, 21 Mar 2018 10:30:22 GMT

Would you be able to share a sample QVW to take a look ?

Re: Take value from dimension in expression

Nagaraju_KCS — Wed, 21 Mar 2018 10:36:03 GMT

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)

Re: Take value from dimension in expression

YoussefBelloum — Wed, 21 Mar 2018 10:38:46 GMT

you mean this ?

Aggr(ONLY({<POD = {"=Sum(CONSUMO_TOTALE_KWH)/([coefficiente]*12) < 1000"}>} [coefficiente]),coefficiente)

Re: Take value from dimension in expression

YoussefBelloum — Wed, 21 Mar 2018 10:44:06 GMT

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"