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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
wnorwood
Contributor III
Contributor III

Limit Based on Selected Expression Value in Straight Table

Hello,

I have two straight tables.  One that is at a summary level and one that is the details.  I would like to be able to limit the details based on selections made in the summary.  The catch is that I want to be able to do this by selecting a value in the table and apply limits based on the column it is selected from as well as the row (the dimension).  Below is a sketch of what I am trying to do.

Can someone tell me if this is even possible?  Many thanks!

Open Tickets2.png

The Expressions are:

Open Count = SUM({<[Created]={'>=$(vStartDate)'}>} OPEN_TICKET_COUNT)

Total Count = SUM({<[Created]={'>=$(vStartDate)'}>} TICKET_COUNT)

1 Reply
wnorwood
Contributor III
Contributor III
Author

Quick note... just noticed that I put 7 tickets in the Total Count details.  That should have just been through a1 through a6. Got a little carried away with the copy/paste.