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: 
antonybi
Creator
Creator

Need help on avg%

Hi Folks,

Please help me out to calculate avg % for the corresponding Market. 

PFB, for your reference.

cap1.JPG

Look forward to quick response.

Thanks,

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar

Is this what you need?

image.png

View solution in original post

6 Replies
sunny_talwar

What expressions are you using right now? and what is the output you are looking to get? Can you may be share a sample?

antonybi
Creator
Creator
Author

Hi Sunny,

Thanks for the quick response.

I've two measures datavalueA and datavalueB.

In straight table , I've taken two dimensions Market and data and expressions are
Avg(datavalueA) and Avg(datavalueB) and showing in% as I highlighted in red.

Now I have to show one more measure which is having avg of datavalueA and dataavalueB(hightlited in red mark).

Kindly help.
sunny_talwar

You want to find the average of the two expressions? May be this

(Avg(datavalueA) + Avg(datavalueB))/2
antonybi
Creator
Creator
Author

Sunny check the below attachment for the same.

Dimension: Market

Dimesion2: Data

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.

sunny_talwar

Is this what you need?

image.png

antonybi
Creator
Creator
Author

Yes Sunny thanks for help. this is what exactly I need