topic Re: Avg at expressn in QlikView

Avg at expressn

Mon, 17 Jun 2013 10:31:42 GMT

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

but the desired O/P should be,

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 ????

RedSky001 — Mon, 17 Jun 2013 10:55:55 GMT

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

Mon, 17 Jun 2013 11:22:40 GMT

hey mark,

cant do tht

RedSky001 — Mon, 17 Jun 2013 11:28:29 GMT

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.

Mon, 17 Jun 2013 11:58:28 GMT

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.

Tue, 18 Jun 2013 03:55:10 GMT

Hey Experts / Gurus,

any suggestions Pls.....