topic Can I create an independent object? in QlikView

Can I create an independent object?

prabhu0505 — Thu, 25 Feb 2010 10:46:10 GMT

Let me fine tune my question.

Say, I have two table box(T1 & T2) and some other objects in my sheet. Is it possible to avoid reflection of the selection made in one table box to another table box but I dont care for other objects?

Point:

T1 and T2 should be independent i.e. my selection of row in T1 should not reflected in T2.

Can anyone help me please?

Can I create an independent object?

Thu, 25 Feb 2010 10:50:41 GMT

Instead of using a table box you could use a straight table type of chart and then check 'detached'.

Regards,

Gordon

Can I create an independent object?

prabhu0505 — Thu, 25 Feb 2010 14:05:25 GMT

Thanks for your reply Gordon.

But actually I'm not going to use any measures or facts in my table. Because of that if I tried to load my data into straight table it is not getting loaded.

Example :

A B C are the values, I'm going to load in the table not A,B,C,sum(D).

So it is not getting loaded in straight table case.

Can I create an independent object?

Thu, 25 Feb 2010 15:16:22 GMT

You can always create a dummy expression (such as a definition of 1) and then run the following code to make the width of the expression column 0 which will hide it (you only need to run it once):

sub AdjustCH

set chart = ActiveDocument.GetSheetObject("CH99") ' CHANGE THE OBJECT ID
set p = chart.GetProperties

set expr = p.Expressions.Item(0).Item(0).Data.ExpressionVisual ' group.expression numbered from 0
expr.ColWidth = 0
chart.SetProperties p

end sub

Regards,

Gordon

Can I create an independent object?

vidyut — Thu, 25 Feb 2010 16:43:51 GMT

If you ún-check the 'Suppress Zero Values'in Presentation Tab, You could use the Straight table chart with only dimensions and no expressions. No need of writing macros. Quite a useful feature.

Can I create an independent object?

vidyut — Thu, 25 Feb 2010 16:45:05 GMT

Though, for your original problem, using Set Analysis might be a better option

Can I create an independent object?

Thu, 25 Feb 2010 16:54:29 GMT

hello,

Yes you can do it.

I use thefollowing in script to provide a separate tabnle ie a summary table static , ( not using detached) for when user views document they can view their data plus a regional view.


table123:
join (table123)
load
 variable1 as staticvariable1,
 variable2 as staticvariable2
resident mymaintable;

Can I create an independent object?

prabhu0505 — Sat, 27 Feb 2010 08:12:00 GMT

Thanks for your timely help

Can I create an independent object?

prabhu0505 — Sat, 27 Feb 2010 08:42:39 GMT

Hi cjwhit,

Really it is a very useful tip.

But I have a doubt on it. That is whether it take more memory?

From your example:

variable1 and variable2 are already available in the document, if I'm again loading it's value using staticvariable1 and staticvariable2 whether the values will loaded again? If no then how it works?

Can I create an independent object?

prabhu0505 — Sat, 27 Feb 2010 08:57:23 GMT

Hi All,

Thanks for your overwhelming response

Can I create an independent object?

stephencredmond — Sat, 27 Feb 2010 12:53:14 GMT

Hi,

Just to add my two-pence, I would create a straight table as others have suggested with an expression of:

Sum({1} 1)

In the Presentation tab you can choose to hide the expression column.

Then, selections on the document will not effect this table.

(see attached)

Regards,

Stephen