Limiting data displayed in Straight Table

[#1]

HI I'm new to Qlik view and learning on my own.   I' ve been doing research on set analysis and must admit some of it is beyond my knowledge, but I continue to learn daily.

In my app I'd like to display some stats on the dashboard such as:

Number of estimates due this week

Number pass due

Number due next week

I have the following syntax and it displays the correct record count

=count(distinct if(inWeek(EstimationEndDate,Today(),0) and EstimateComplete='No',[RequestNo]))& ' Estimations Due this Week'

=count(distinct if(EstimationEndDate<weekstart( Today())and [EstimateComplete]='No',[RequestNo]))& ' Estimations Pass Due'

=count(distinct if(inWeek(EstimationEndDate,Today() and EstimateComplete='No',+1),[RequestNo]))& ' Estimations Due Next Week'

I'd like to have an action when the box or button displaying the number is clicked then a list comes up with the detail records behind that number.

I've tried a table box with a calculated condition but it produces the data if one of the statements is true and not both.

Multi table box doesn't seem to provide me an option to set conditions

I've tried a straight table a few different ways.  I'm also not sure what to do with the expressions in a straight table so I've played with a few things there.

Straight table with  group

Straight table with limiting the data in my dimensions

Again neither one of these seems to work.

Any assistance or thoughts are appreciated.

Thanks

Liz

[Gabriel]

Hi,

I think your best option is to create 3 charts for each of your KPIs. And use conditional show/hide to display each chart.

Just set up 3 variables and use it in Layout for each chart to display the chart whenenver each KPI is selected.

In each chart ensure your expression used in the KPI is in used to pick out relevant data.

Hope that helps