Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
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
Partner

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
Partner

Sure. Just update your expressions as following:

Sum(TOTAL Value1)

Sum(TOTAL Value2)

uacg0009
Partner
Partner

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
Partner

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.