Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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.