topic Re: Display Straight Table Total value in another object in QlikView

Display Straight Table Total value in another object

Wed, 27 May 2015 12:52:03 GMT

Do we have an option in QV 11 to display 'Straight Table Total value' from one object to display in another object like Straight Table or other charts?

Andrew

Re: Display Straight Table Total value in another object

sunny_talwar — Wed, 27 May 2015 15:21:01 GMT

You should be able to use the Aggregate function to replicate the Total of your straight table in a text box

Sum(Aggr(YourExpression, yourDimensionsfromStraightTable))

If the above doesn't give you what you are looking for, would you be able to share a sample of what you are trying to achieve?

Best,

Sunny

Re: Display Straight Table Total value in another object

cesaraccardi — Wed, 27 May 2015 15:21:32 GMT

Hi Andrew,

I am afraid there isn't such option, so you will have to recalculate the Total value in the other charts. Can you be more specific about how you want to use that total in the other objects?

Cesar

Re: Display Straight Table Total value in another object

Thu, 28 May 2015 07:28:39 GMT

Hi,

Thanks for your inputs.

However, I am aware of this Aggregate function, and can calculate and display the total accordingly. I am looking some easy way to display Straight Table total value in separate object. The reason is, my straight table is having 8 dimensions and 9 calculate expressions and I need to write the very long expressions again. Since, I just need to show the Total value, am looking some option or function (if Qlik has it) to call the value from the existed object.

Andrew

Re: Display Straight Table Total value in another object

Anonymous — Thu, 28 May 2015 07:40:25 GMT

I am not aware of any way to do what you are after.

But it can often be useful to store expressions in variables so they can be used in multiple places.

Simple example:

Set variable in load script :
- set vToday = today() ;
Dollar expand the variable in a Text Box
- =$(vToday)

Re: Display Straight Table Total value in another object

antoniotiman — Thu, 28 May 2015 07:52:34 GMT

Hi Andrew,

You can use macro to take the value of cell and store in variable, like this

set obj = ActiveDocument.GetSheetObject("CH561")
set v = ActiveDocument.Variables("vTotal")
v.SetContent obj.GetCell(1,5).text*1,true

etc.

The question is where call this macro

e.g. in open sheet or button

Regards,

Antonio

Re: Display Straight Table Total value in another object

Anonymous — Thu, 28 May 2015 08:22:57 GMT

Before contemplating macros it would be wise to read this blog post.

Macros are Bad

Re: Display Straight Table Total value in another object

antoniotiman — Thu, 28 May 2015 08:55:02 GMT

Hi Bill,

for long time I use this macro and no problem (desktop,server).

The blog which You report is generic, however, very important.

Regards,

Antonio