Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Avg at expressn

Dear All,

I have a pivot chart whr dimensionwise i had to calculate avg count percentage,

used the expression, 

avg(aggr(Count(FILE_NO)/Count(total<C_QUESTION> FILE_NO),C_QUESTION,C_STATUS

))

this works fine, see the pic

StatusComplianceNANComplianceTotal
ProcessQuestion%Count%Count%Count%Count
FixingA100%30----100%30
FixingB100%30----100%30
FixingC70%2130%9--50%30
FixingTotal90%8130%9--75%90

but the desired O/P should be,

StatusCNANCTotal
ProcessQuestion%Count%Count%Count%Count
FixingA100%30----100%30
FixingB100%30----100%30
FixingC70%2130%9--50%30
FixingTotal90%8110%9--75%90

whts happening is its not counting the misssing values, so taking avg as 30 instead of 10 %,

Please somebody let me know wht chnages to b done in the expression used, wht wrong hav i done ????

5 Replies
RedSky001
Partner - Creator III
Partner - Creator III

Can you provide a sample of the data prior to it being aggregated?

Not applicable
Author

hey mark,

cant do tht

RedSky001
Partner - Creator III
Partner - Creator III

Can't do it or wont do it?

If it's "wont" and the reason is the data is senative, you could always scramble the data.

It's difficult to help you without knowing what your data is.

Not applicable
Author

both !!!!!  already have a vio  la   tion on ma name, so avoiding the risk

whts scr am ble will try tht video,

thanks n respond to my post tomorrow.

Not applicable
Author

Hey Experts / Gurus,

any suggestions Pls.....