topic Dimensions values Adds up in QlikView

Dimensions values Adds up

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

I have a situation where the Dimension values are adding up instead of showing the individual value.

Value1 and Value 2 are the dimensions and when selected multiple ID's the Field values are adding up and it's populating the Sum value

O/P which i got:

ID Customer Value1 Value2

1001 ABC 35 110

1002 xyz 35 110

Instead of

Actual O/P:

ID Customer Value1 Value2

1001 ABC 15 90

1002 xyz 20 20

Please Help me out.

MindaugasBacius — Wed, 10 Oct 2018 08:33:28 GMT

Try to aggregate in backend:

tmp:

load ID

,Customer

,Sum(Value1) as Sum_Value1

,Sum(Value2) as Sum_Value2

resident Sales

Group by ID, Customer;

vardhan1305 — Wed, 10 Oct 2018 08:38:56 GMT

Its not possible to do in backend as it has many records.. is there any way to do it in front end.

MindaugasBacius — Wed, 10 Oct 2018 12:14:47 GMT

Sure. Just update your expressions as following:

Sum(TOTAL Value1)

Sum(TOTAL Value2)

uacg0009 — Thu, 11 Oct 2018 02:06:06 GMT

Hi harsha,

could you please give a sample of your qvw, so I can see your table and dimension and expressions to try to find out what the problem is.

Aiolos

shreya_nadkarni — Thu, 11 Oct 2018 03:06:05 GMT

try the aggr() in frontend

Jesh19 — Thu, 11 Oct 2018 20:12:58 GMT

what is the expression that you're using.

Can you please share some sample data.