Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Detaching filter from straight table

Hello,

I'm in trouble detaching filter from straight table. I have a straight table showing a selection of one attribute's values. When a single value is clicked, nearby graphs are influenced accordingly, but I'd like the table to be static - the user should not see anything on click. Is it possibile to achieve it?

Thank you!

16 Replies
Anonymous
Not applicable
Author

Sum({<Year=>}Sales)

Chanty4u
MVP
MVP

try this

Field=>    u can include any num of fileds

Sum({<Year=>,Month=>,Day=>}Sales)

Not applicable
Author

I tried this, and also rgv rand's version, adjusting it to my dataset. I think it should be:

Sum({<d18=>}d18)

Because d18 is the only field I need to show in the straight table view.

The expression itself is OK, but after I insert it, I receive the "not valid dimension" error message!

Chanty4u
MVP
MVP

try

Sum({<[d18]=>}[d18])

Not applicable
Author

Thank you... but I still get "invalid dimension".

Chanty4u
MVP
MVP

try

lik below

=Count({$<<[$(=concat({1<Stable={'[d18]'}>}distinct $field,']=,[')&']=')>}Sales)

Not applicable
Author

Thank you - selection works, same results as this:

Count({1<d18-={'Si','No','Nessuno'}>}d18)

Still, the table filters.