topic Re: Straight Table Expression Sum as Variable in QlikView

Straight Table Expression Sum as Variable

Thu, 10 May 2012 19:28:08 GMT

Hi Folks,

I cretaed the Straight Table. I need to use the expression sum in the Straight table as variable. How can I do that?

Can I use the expression in the Startight Table as the column out side of the table chart?

Thanks & Regards,

Siri

Table Chart Expression Sum as Variable

danielact — Thu, 10 May 2012 19:55:09 GMT

You can't create expressions in a table box. Use a straight table instead.

Table Chart Expression Sum as Variable

Thu, 10 May 2012 22:13:39 GMT

Hi thanks for your reply. Sorry I am asking wrongly.

My question regarding Straight table only.

Table Chart Expression Sum as Variable

oscar_ortiz — Thu, 10 May 2012 23:06:18 GMT

You can create a variable in your document and use that as part of the expression: For example create a variable vExpression with the definition of =Sum(Sales) then use the $(vExpression) in your chart's expression.Good luck

Table Chart Expression Sum as Variable

Fri, 11 May 2012 11:25:24 GMT

Hi Ortiz, Thanks for your reply.

I need the use the total sum of the expression in the straight table as variable. Please find the below Image.

Please help me in this.

Thanks & Regards,

Siri

Re: Table Chart Expression Sum as Variable

jonathandienst — Fri, 11 May 2012 11:52:06 GMT

Define a variable (lets call it vTotalRAM):

In your script:

Set vTotalRAM = Sum(Aggr(Sum(RAM), QVWName));

After reloading you can use the expression $(vTotalRam) to get the value which should be the same as the table total.

Regards

Jonathan

Table Chart Expression Sum as Variable

Fri, 11 May 2012 12:25:37 GMT

Hi Jonathan, Thanks for Your Reply.

The RAM is not a column. In the above straight table, QVW NAME, Document Size and Concurrent Users are the columns. Others Expression Values.

RAM Initial = [SIZE(KB)]*vFileSizeMultiplier

RAM USER=([SIZE(KB)]*vFileSizeMultiplier*vUserRAMratio)/100

RAM=([RAM USER]*[Concurrent Users])+[RAM Initial]

So I need to use the total sum value as vaeiable and RAM as the List box.

Please provide your suggestions.

Thanks & Regards,

Siri

Re: Table Chart Expression Sum as Variable

jonathandienst — Fri, 11 May 2012 13:19:43 GMT

Then use this instead:

Sum(Aggr(Sum(([RAM USER] * [Concurrent Users]) + [RAM Initial]), QVWName))

Regards

Jonathan

Re: Straight Table Expression Sum as Variable

Thu, 28 Apr 2016 16:24:40 GMT

This helped me a lot. Thank you very much.