Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
abonnery
Contributor III
Contributor III

Set Analysis MaxString on one dimension

Dear Qlik Experts, 

 

I am trying to do a simple set analysis where the only criteria includes a MaxString. Here is the line of code I have tried for now: 

sum({$<[Cost Baseline Version - FA]={"(=MaxString(All [Cost Baseline Version - FA]))"}>} [EAC - FA]/1000000)

The results with this line of code is 0 for everywhere.

The line MaxString(All [Cost Baseline Version - FA]) works and directs me where the correct answer, I just don't know how to do a set analytic that sum all 'EAC -FA' whith this maxtring as a filter. 

Thank you very much for your help. 

Labels (2)
1 Solution

Accepted Solutions
AshutoshBhumkar
Partner
Partner

Hello,

Try below

sum({$<[Cost Baseline Version - FA]={"$(=MaxString(All [Cost Baseline Version - FA]))"}>} [EAC - FA]/1000000)

or

sum({$<[Cost Baseline Version - FA]={$(=MaxString(All [Cost Baseline Version - FA]))}>} [EAC - FA]/1000000)

Reference

https://community.qlik.com/t5/New-to-Qlik-Sense/set-analysis-with-MaxString/td-p/738794

 

Thanks,
Ashutosh

View solution in original post

1 Reply
AshutoshBhumkar
Partner
Partner

Hello,

Try below

sum({$<[Cost Baseline Version - FA]={"$(=MaxString(All [Cost Baseline Version - FA]))"}>} [EAC - FA]/1000000)

or

sum({$<[Cost Baseline Version - FA]={$(=MaxString(All [Cost Baseline Version - FA]))}>} [EAC - FA]/1000000)

Reference

https://community.qlik.com/t5/New-to-Qlik-Sense/set-analysis-with-MaxString/td-p/738794

 

Thanks,
Ashutosh