topic Aggregate Function not showing on all rows in QlikView

Aggregate Function not showing on all rows

c1bs — Tue, 07 Mar 2023 14:18:51 GMT

Hi forum,

I have a problem with my visualizations on QlikView. I want to calculate Quantity per Month based on the value from the Quantity and per Code itself (Code field contain several values also).

Currently, my aggregate function not showing on all rows as you can see like the sample below:

It only shows on one row and showing NULL on other rows. What I want is to show it on all rows.

Some notes:
1. The red marked are the expressions (Month & Qty per Month)

Month = Date([Date of Transaction]),'MMMYY')

Qty per Month = Aggr(Sum([Quantity]),[Month],[Code])

2. Somehow, I can't solve this by Editing the Script, I can only work this by using expressions.

3. Please assume that all fields have other values also, not like the sample above.

Thank you and hopefully I get feedback very soon from the forum.

Cheers!

Re: Aggregate Function not showing on all rows

E_Røse — Tue, 07 Mar 2023 14:44:31 GMT

Try to add the nodistinct keyword within your aggr function.

When you leave that out, the aggr-function will only fill one value per combination of Month and code. With nodistinct, the value will berepeated for each row.

Please like and mark my answer as a solution, if it resolved your issue.

Re: Aggregate Function not showing on all rows

c1bs — Wed, 08 Mar 2023 02:56:23 GMT

Thank you!