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

[#1]

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

Thanks, Wei

[trdandamudi · Accepted solution]

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...

[rwunderlich]

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

Sum({1} Sales)

-Rob

[neelamsaroha157]

You can also use alternate states.

Create a separate state particularly for this table.

Hope this helps.

[#5]

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