Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How do we create a table at Qlik which wont be filtered by any selector?

How do we create a table at Qlik which wont be filtered by any selector?

Thanks, Wei

1 Solution

Accepted Solutions
trdandamudi
Master II
Master II

Can be done as below:

Say if you have a straight table then

Go to properties

click on General tab

Put a check against "Detached"

That's all you have to do.

Now when you select filters this table will not get effected.

Hope this helps...

View solution in original post

5 Replies
trdandamudi
Master II
Master II

Can be done as below:

Say if you have a straight table then

Go to properties

click on General tab

Put a check against "Detached"

That's all you have to do.

Now when you select filters this table will not get effected.

Hope this helps...

View solution in original post

rwunderlich

Use the set "{1}" in your chart expressions. For example:

Sum({1} Sales)

-Rob

neelamsaroha157
Specialist II
Specialist II

You can also use alternate states.

Create a separate state particularly for this table.

Hope this helps.

Not applicable
Author

Thanks!

So how do we do if we want this table is filtered by one filter? and can we do this in dimension not in expression?

rwunderlich

For example, if you wanted to ignore all filters except for field ProductName. You expression would be:

sum( {1<ProductName=P(ProductName)>} LineSalesAmount)

You can do some filtering of the Dimension using aggr(). Can you explain your use case a bit more before I make a specific example?

-Rob

http://masterssummit.com

http://qlikviewcookbook.com