Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
Hope the attached qvw solves ur problem
hi Bhagirath
please attach the qvw file
Does this solves your problem ?
if yes you can mark this as correct answer
if not let me know what is still pending
didn't you received the one in earlier reply
my qlikview is personal edition so not opening ur attached qvw file
please send personal edition qvw file
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)
mr Bhagirath
thanks for your response
You can also use
avg({<DID=>}SALARY)
you are most welcome