hi every body

[satheshreddy]

hi,

how to find out avg in chart.

i have table columns are

eid,ename,did,salary

i take a filter of eid

select the eid value then to display the that particular did sum(salary) and also avg of that particular did salary.

kind regards

esreddy

Message was edited by: s r

[Anonymous]

Hope the attached qvw solves ur problem

[satheshreddy]

hi Bhagirath

please attach the qvw file

[Anonymous]

Does this solves your problem ?

if yes you can mark this as correct answer

if not let me know what is still pending

[Anonymous]

didn't you received the one in earlier reply

[satheshreddy]

my qlikview is personal edition so not opening ur attached qvw file

please send personal edition qvw file

[Anonymous · Accepted solution]

ohhh

Create an application, load the excel you have attached with scripts

now in front end

Create a variable in the settings>variable Overview> add

vListDID and define it as below

=Concat(distinct DID,',')

and then finally create

Create a pivot with DID as dimension

sum({1<DID={$(vListDID)}>}SALARY)

avg({1<DID={$(vListDID)}>}SALARY)

[satheshreddy]

mr Bhagirath

thanks for your response 

[sagarkharpude]

You can also use

avg({<DID=>}SALARY)

[Anonymous]

you are most welcome