Qlik Community

Qlik Sense Advanced Authoring

Discussion board where members can learn more about Qlik Sense Advanced Authoring.

Announcements
See why Qlik is recognized as a Leader for the 10th year in a row – and discover how Qlik can help put your business in the lead. Get Report
Highlighted
kluckow0128
New Contributor III

How to break dynamic expression with aggr from interacting with a filter

Hello,

I'm trying to get this formula to not move when a RevenueRecognizedDate is selected, but it keeps changing.  Any ideas?

sum({1<EventType = {'Order','Change Order'}, Work_Order_Type__c = {'Install'}, IsOrderCancelled = {0}, RollingMonthFlag={1}, IsWorkOrderStatusCancelled={0}, RevenueRecognizedDate =>} Total_Labor_Cost__c)/

Aggr(NoDistinct sum({1<EventType = {'Order','Change Order'}, IsOrderCancelled = {0}, IsItemCancelled = {0}, RollingMonthFlag={1}, RevenueRecognizedDate =>} Total_Retail_Price__c),"Month and Year")

 

 

Labels (1)
2 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: How to break dynamic expression with aggr from interacting with a filter

Try this.

Aggr({<RevenueRecognizedDate =>}NoDistinct sum({1<EventType = {'Order','Change Order'}, IsOrderCancelled = {0}, IsItemCancelled = {0}, RollingMonthFlag={1}, RevenueRecognizedDate =>} Total_Retail_Price__c),"Month and Year")

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Highlighted
kluckow0128
New Contributor III

Re: How to break dynamic expression with aggr from interacting with a filter

Thanks for the suggestion, however, it still filters down to the RevenueRecognizedDate range selected using that set analysis.