topic Re: Ignoring selections in Set expression in App Development

Ignoring selections in Set expression

Raju_6952 — Wed, 28 Feb 2024 07:58:41 GMT

Hi,

I am displaying max value of one particluar measure in kpi and my requirement is to display the maximum value of current and even if I select other dates also it should remain uneffected on that KPI,

Sum({<Date={'$(=max(Date))'},Name={'EPI'}>}value) using this formula currently but its changing when I select other dates without the current date.

any suggestions would be highly appreciated.

Thanks in Advance,

Raju

Re: Ignoring selections in Set expression

ali_hijazi — Wed, 28 Feb 2024 08:43:08 GMT

that's because the max(Date) is affected by other selections so the maximum is not always the same
so you either ignore selections on specific fields inside the max() or you use the whole set of data {1}
so your expression would be something like
Date={"$(=max({1}Date)"}
or if you want to ignore all possible selections made on the fields of the calendar you could write something like:
{<$(='[' &concat(distinct{<$Table={calendar}>}$Field,'],[') &']')>}
change the table name to the appropriate name of your calendar table in your schema

Re: Ignoring selections in Set expression

MayilVahanan — Wed, 28 Feb 2024 08:40:25 GMT

Depends on the requirement, Try like below

Sum({<Date={'$(=max({1}Date))'},Name={'EPI'}>}value)

Sum({<Date={'$(=max({<DateField=, YearField=, TimeFilters=>}Date))'},Name={'EPI'}>}value)