topic Re: Need help on avg% in QlikView

Need help on avg%

antonybi — Sat, 16 Nov 2024 04:49:39 GMT

Hi Folks,

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

PFB, for your reference.

Look forward to quick response.

Thanks,

Re: Need help on avg%

sunny_talwar — Tue, 08 Jan 2019 13:41:44 GMT

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

Re: Need help on avg%

antonybi — Tue, 08 Jan 2019 13:50:25 GMT

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%

sunny_talwar — Tue, 08 Jan 2019 13:57:06 GMT

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

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

Re: Need help on avg%

antonybi — Tue, 08 Jan 2019 14:03:43 GMT

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%

sunny_talwar — Tue, 08 Jan 2019 14:10:59 GMT

Is this what you need?

Re: Need help on avg%

antonybi — Tue, 08 Jan 2019 14:15:09 GMT

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