topic Can we use Variables in Class Function? in QlikView

Can we use Variables in Class Function?

Wed, 15 May 2013 23:23:51 GMT

I have 3 Variables defined as follows

vMinChargedAmount Min(CHARGED_AMOUNT)

vMaxChargedAmount Max(CHARGED_AMOUNT)

vChargedAmountWidth ($(vMaxChargedAmount) - $(vMinChargedAmount))/10

I am creating a bar chart with dimension as follows

=Class(CHARGED_AMOUNT,$(vChargedAmountWidth))

Expression

Count (DISTINCT CHARGED_AMOUNT)

Basically I am trying to calculate the Class width through variable. If I hardcode value it works. But when I use variables I am getting error

See the attached file for Screens (Manual_Definition.PNG: OK, Variable_Calculated.PNG Not OK)

What is the mistake I am making?

Thank you

Re: Can we use Variables in Class Function?

rwunderlich — Thu, 16 May 2013 03:23:43 GMT

I think you need to force the variables to be a single calculation. Add an "=" to your variable value defintion. That will result in the the calculated number being substituted in the class() function instead of the expression.

-Rob

http://robwunderlich.com

Re: Can we use Variables in Class Function?

Thu, 16 May 2013 12:38:06 GMT

Thank you Rob Wunderlich. Appreciate your help