Discussion board where members can get started with QlikView.
Please help me out to calculate avg % for the corresponding Market.
PFB, for your reference.
Look forward to quick response.
Go to Solution.
Is this what you need?
View solution in original post
What expressions are you using right now? and what is the output you are looking to get? Can you may be share a sample?
You want to find the average of the two expressions? May be this
(Avg(datavalueA) + Avg(datavalueB))/2
Sunny check the below attachment for the same.
Exp1: Avg(datavalue_A) //showing correct
Exp2: Avg(datavalue_B) //showing correct
Exp3: Sum(datavalue_A)+Sum(datavalue_B) // showing wrong
As soon as I select Market it should reflect avg of both datavalue_A and datavalue_B
Hope this clear.