Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
lalita_sharma
Contributor III
Contributor III

Qlik Sense AGGR function set expression

Hi 

I have created a straight table which looks like below

Risk IdWorkstreamWorkstream IdKPI name
R004CM13
R007CM13
R027AR53
R028AR53
R030CM13
R033CM13
R034DA23
R035DA23

 

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.

1 Reply
lalita_sharma
Contributor III
Contributor III
Author

Hi All

Can someone please help with above query.