topic Re: Using variable in a Table Box in QlikView

Using variable in a Table Box

anuradhaa — Thu, 09 May 2013 05:44:37 GMT

Hi,

I have define a variable name "cost" in document properties,

my expression is

"=round((140*Time)/Quantity,2)"

Now i want to show that variable in a table box.

Please tell me how to do that.

I have attached my qvw here.

Thanks

Re: Using variable in a Table Box

jagan — Thu, 09 May 2013 06:09:54 GMT

Hi,

Use Aggregate function like sum, because you have multiple values, please check below expression, your expression works only when you select any ID.

=round(Sum((140*Time)/Quantity),2)

Hope this helps you.

Regards,

Jagan.

Re: Using variable in a Table Box

Gysbert_Wassenaar — Thu, 09 May 2013 07:27:15 GMT

You can't use variables or expressions in a table box. A table box can only show fields. You'll have to use a straight table object. Create a new Chart object, choose Straight Table as chart type, add your dimensions and finally add your expression.

Re: Using variable in a Table Box

anuradhaa — Thu, 09 May 2013 08:34:02 GMT

Thanks All