Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
prabhu0505
Specialist
Specialist

Can I create an independent object?

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?

1 Solution

Accepted Solutions
vidyut
Partner - Creator II
Partner - Creator II

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.

View solution in original post

10 Replies
Not applicable

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

Regards,

Gordon

prabhu0505
Specialist
Specialist
Author

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.

Not applicable

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



vidyut
Partner - Creator II
Partner - Creator II

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.

vidyut
Partner - Creator II
Partner - Creator II

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

Not applicable

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;


prabhu0505
Specialist
Specialist
Author

Thanks for your timely help

prabhu0505
Specialist
Specialist
Author

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?

prabhu0505
Specialist
Specialist
Author

Hi All,

Thanks for your overwhelming response