Limit Based on Selected Expression Value in Straight Table

wnorwood — Tue, 26 Jan 2016 15:49:16 GMT

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!

The Expressions are:

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

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

Re: Limit Based on Selected Expression Value in Straight Table

wnorwood — Tue, 26 Jan 2016 15:56:48 GMT

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.

topic Limit Based on Selected Expression Value in Straight Table in QlikView

Limit Based on Selected Expression Value in Straight Table

Re: Limit Based on Selected Expression Value in Straight Table