Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
amita1621
Contributor III
Contributor III

Average of Average at total level

Hi,

I am working on a graph where i have a bar and a line , one counts the transaction work done by a processor and the other one is sum(AvgProcessor) which depicts the if a tower has 4 processor then on average 1/4 processor work on a transaction.

Now when i see the total of avg processor based on Year it comes as average value not the total processor.

How could this  be resolved in QLikview.

Attached in the file for reference. Need quick guidance.

Thanks in advance.

10 Replies
Sergey_Shuklin
Specialist
Specialist

Hello!

Is this your case?

avg_sum_pic1.png

amita1621
Contributor III
Contributor III
Author

Do these options get disabled when we use Bar and line Chart?

Sergey_Shuklin
Specialist
Specialist

Yes, of course you're right. My apologize. Here the solution with bar-line chart.

avg_sum_pic2.png

If your Year dimension will be containing more than one value, so you'll have to add to aggr() function one more aggr-dimension, like aggr( sum(), Year, Tower)

amita1621
Contributor III
Contributor III
Author

so like  in the data i have 13 more elements like type of the transactions, and country codes etc do we need to add in aggregate

Sergey_Shuklin
Specialist
Specialist

Only those dimensions that goes to the chart should be aggregated.
amita1621
Contributor III
Contributor III
Author

But i am still facing the issue my numbers are getting higher than expected , the count of processor comes more than it is.

Sergey_Shuklin
Specialist
Specialist

Can you share a piece of scrumble data?
amita1621
Contributor III
Contributor III
Author

Hi,

 

I am attaching a screenshot of QlikView and expression, I have processor as Cas 5, Prof 1, Prop 4, Spec 5 so total is 15 so when I divide the amount 

=260320/14813

it gives 17 whereas it should have been 15 only as Total Processor 

Sergey_Shuklin
Specialist
Specialist

There will be helpful to figure out how values 260.320 and 14.813 came.
Can you please share a table with original values and expected result?