Function in a Variable

[#1]

Hi

I have a pivot chart where I display data group by Technician's teams , per technicians ...

In the expression I use a function stored in a variable  "=$(vBcPossible)"

this variable should make the calculation for each row (when I expand  the pivot) but now It always display the result for ALL the lines display . So I have a SUM for the total Team , and not per technician

the function is doing a SUM based on condition

[Anonymous · Accepted solution]

Hi,

Remove the '=' sign in the variable defintion. Having equal sign in here forces QlikView to evaluate the expression first and then pass the result into the chart. Without it it will interprate expression per dimensions.

Regards,

Janusz

[jagan]

Hi,

Remove = sign in the variable declaration, if you give = it will evaluate the expression, that is why you are getting the same value for all the rows.

Regards,

Jagan.

[#4]

perfect , now I understand and it's logic