topic Function in a Variable in QlikView

Function in a Variable

Wed, 16 Jul 2014 08:28:16 GMT

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

Re: Function in a Variable

Anonymous — Wed, 16 Jul 2014 08:39:27 GMT

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

Re: Function in a Variable

jagan — Wed, 16 Jul 2014 08:41:58 GMT

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.

Re: Function in a Variable

Wed, 16 Jul 2014 08:45:01 GMT

perfect , now I understand and it's logic