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
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
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.

Labels (1)
1 Reply
lalita_sharma
Contributor III
Contributor III
Author

Hi All

Can someone please help with above query.