Set Analysis MaxString on one dimension

abonnery — Sat, 16 Nov 2024 16:52:13 GMT

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.

Re: Set Analysis MaxString on one dimension

AshutoshBhumkar — Tue, 04 Jan 2022 09:21:33 GMT

Hello,

Try below

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

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

topic Re: Set Analysis MaxString on one dimension in App Development

Set Analysis MaxString on one dimension

Re: Set Analysis MaxString on one dimension