Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vardhan1305
Contributor II
Contributor II

Dimensions values Adds up

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.

6 Replies
MindaugasBacius
Partner - Specialist III
Partner - Specialist III

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
Contributor II
Contributor II
Author

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

MindaugasBacius
Partner - Specialist III
Partner - Specialist III

Sure. Just update your expressions as following:

Sum(TOTAL Value1)

Sum(TOTAL Value2)

uacg0009
Partner - Specialist
Partner - Specialist

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
Partner - Creator
Partner - Creator

try the aggr() in frontend

Jesh19
Creator II
Creator II

what is the expression that you're using.

Can you please share some sample data.