Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
accrewchief
Contributor II
Contributor II

Display number from a selected table and column

Hello and pre thanks for any help. 

I have a table with several columns of data. One particular column i have counts based of filters previously set in the table. The column displays a Total count at the top that i both created and want to see. Now i am adding a Chart that i wish  to only display the number from that certain table and that certain column total number that is displayed. The problem with a simple = is that my new chart doesn't see the pre set filters in the table. I want it to to act more like Excel in which that lets say this cell(A) = the exact number displayed in another cell(B) but the cell B is the column total number displayed. Ideas?

4 Replies
lorenzoconforti
Specialist II
Specialist II

Not 100% clear as to what you are trying to achieve

"One particular column i have counts based of filters previously set in the table" - what do you mean? When you filter your data you normally filter the set so selections propagate to all the other objects in the dashboard. Are you saying you are using set analysis in some of the expressions?

"Now i am adding a Chart that i wish to only display the number from that certain table and that certain column total number that is displayed." - can you just replicate in the chart the same expression you have in the table?

Can you upload your dashboard or provide some screenshots of what is the issue and what you are trying to achieve?

accrewchief
Contributor II
Contributor II
Author

2020-01-06_14-53-01.jpg

accrewchief
Contributor II
Contributor II
Author

I just want the number on the left to be what the number on the right is. And if the number on the right is 3 then the number on the left is 3 and so on. 

lorenzoconforti
Specialist II
Specialist II

These are two different objects so that type of link is not possible. Just replicate the same expression

What expression are you using for the total? What kind of filters were you referring to?