topic Re: Chart Expression aggregation in QlikView

Chart Expression aggregation

arsenal1983 — Fri, 10 Sep 2021 11:14:48 GMT

Hello,

I have an issue with my chart (table) expression.

The Total Count expression appears only in one row for each PATY/MONTH. I need to have it in every row.

Dimensions:

PATY and MONTH comes from the source detail data,

CATEGORY is calculated dimension - combined if and class function

Expressions:

SELLERS COUNT =count(DISTINCT BER.SELLER_SID)

TOTAL COUNT = aggr(count(DISTINCT SELLER_SID), MONTH, PATY)

How can I reach such effect?

stevejoyce — Fri, 10 Sep 2021 15:20:40 GMT

try TOTAL COUNT = aggr(nodistinct count(DISTINCT SELLER_SID), MONTH, PATY)

or i think this should work also...

count(Total <MONTH, PATY> DISTINCT SELLER_SID)

marcus_sommer — Fri, 10 Sep 2021 15:20:42 GMT

Try it with:

TOTAL COUNT = sum(aggr(count(DISTINCT SELLER_SID), MONTH, PATY))

- Marcus

arsenal1983 — Mon, 13 Sep 2021 07:05:17 GMT

that works:

TOTAL COUNT = aggr(nodistinct count(DISTINCT SELLER_SID), MONTH, PATY)

arsenal1983 — Mon, 13 Sep 2021 07:05:59 GMT

it only change that I got 0 instead of null.