topic Re: Assistance with expression in QlikView

Assistance with expression

QFanatic — Wed, 25 Nov 2020 16:16:04 GMT

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 — Fri, 25 Oct 2019 03:32:57 GMT

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 — Fri, 25 Oct 2019 05:52:23 GMT

Thank you very much

QFanatic — Fri, 25 Oct 2019 06:03:05 GMT

Thank you!