Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
antonybi
Contributor

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

Re: Need help on avg%

Is this what you need?

image.png

View solution in original post

6 Replies

Re: Need help on avg%

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
Contributor

Re: Need help on avg%

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.

Re: Need help on avg%

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

(Avg(datavalueA) + Avg(datavalueB))/2
antonybi
Contributor

Re: Need help on avg%

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.

Re: Need help on avg%

Is this what you need?

image.png

View solution in original post

antonybi
Contributor

Re: Need help on avg%

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