Assistance with expression

[QFanatic]

Hello

PFA

in my data, an incident (inc_num) has a period that it was logged, as well as a flagged month, where it was flagged as a certain type of incident.

I want to create a summary chart that gives me

1) total Value where period = flagged_month

2) total Value where period <> flagged month

..in one chart...I would always be looking for Max(period) to get the current report

this is really just sample data to get my idea across. I do NOT want to use the column inc_num in the chart, as there may be millions of records.

Much appreciated.

Lorna

[Arthur_Fong · Accepted solution]

Do you mean like this?

period =flagged month:

=sum({<flag_month ={"$(=max(period))"}>}Value) //same month

period<>flagged month:

=sum({<flag_month -={"$(=max(period))"}>}Value) //same month

Refer qvw attached for the expression applied.

Thanks and regards,

Arthur Fong

[QFanatic]

Thank you very much

[QFanatic]

Thank you!