Qlik Sense AGGR function set expression

[lalita_sharma]

Hi 

I have created a straight table which looks like below

Risk Id	Workstream	Workstream Id	KPI name
R004	CM	1	3
R007	CM	1	3
R027	AR	5	3
R028	AR	5	3
R030	CM	1	3
R033	CM	1	3
R034	DA	2	3
R035	DA	2	3

In Workstream column I have a aggregation expression like

=IF(GetSelectedCount(Workstream)=0,
Aggr(only({$<[Workstream Id]={$(vCalc_StatusPack_DefaultWorkstreamID)},[KPI name]={3}, Date =,[M0 Finish Month]=>}[Workstream]),[Workstream],[Workstream Id],[Risk Id],[KPI name]),
Aggr(only({$<[KPI name]={3},Date =,[M0 Finish Month]=>}[Workstream]),[Workstream],[Workstream Id],[Risk Id],[KPI name]))

In the above expression I have added Date = , so that any selections on the Date filter does not affect the data displayed in the table. But this doesn't seem to work, the table becomes blank as soon as I filter on Date attribute.

I donot have Date attribute in the underlying data of the table I am trying to display in straight table. However it is part of another table in the underlying data model of my app. That is the reason I don't want any selections on date to effect my straight table.

Please help me with the expression.

[lalita_sharma]

Hi All

Can someone please help with above query.