Help with table

[userxxxxxx]

Hello, I'd been working with Qlik Sense for a few weeks now,  currently I have the following data:

I successfully built a table in that only shows the areas having people_whs_gt10 > 0, using this function in the dimension named area:

=IF(worked_hours_gt10>0, area)

Then I added a Date Picker Control, which allows me to select date ranges, I need to only show the people_whs_gt10 > 0 and the date should be the max value from the picker, I tried the following with no luck:

=IF(worked_hours_gt10>0 AND date=MAX(date), area)   : Shows no error in the editor, but in the designer.

[userxxxxxx]

The next thing I tried for the dimension is:

IF(worked_hours_gt10>0 and Aggr(MAX({$}date), area)=date, area)

No luck yet.

[userxxxxxx]

The following actually works:

IF(worked_hours_gt10>0 and date='2021-01-12', area)

But that's not the solution I'm looking for.

[Digvijay_Singh · Accepted solution]

May be something like this in the attached app, the rightmost table has the expression

MaxString({<people_whs_gt10={">0"},date={'$(=date(Max(date),'YYYY-MM-DD'))'}>}area)

[userxxxxxx]

Hello @Digvijay_Singh , the table I'm referring to is the Chart Object:

The formula for the first column (area dimension), is this one:

=IF(worked_hours_gt10>0, area)

This formula along with "Include null values" unchecked, succeed  hiding unwanted rows.

The problem is, I want to use this control:

From the selected range, I want to use the MAX(date), so I modify the formula to something like this:

IF(worked_hours_gt10>0 and Aggr(MAX({$}date), area)=date, area), but this formula is not correct.

BTW: You may ask, Why is he using a range? Well, I use that range to create a bar chart and works just fine.

[Digvijay_Singh]

Could you get chance to explore the app I shared?

[userxxxxxx]

Let me ask the admin for authorization to upload this app.

[userxxxxxx]

Awesome, thanks for the help.