topic Re: Skew calculation in QlikView

Skew calculation

bushpalaamarnat — Fri, 08 Jun 2018 10:27:26 GMT

Hi All, could you please help with what is the best way to write the formula for calculating skewness.

Following is the formula used to calculate the skew of s data set

=Count(DISTINCT {<Inventory_Position = {'OOS'}>} Week&Material&[Supplier Loc]&[Customer Loc])

Count(DISTINCT {<Inventory_Position = {'Low Stock'}>} Week&Material&[Supplier Loc]&[Customer Loc])

Count(DISTINCT {<Inventory_Position = {'Intolerance'}>} Week&Material&[Supplier Loc]&[Customer Loc])

Count(DISTINCT {<Inventory_Position = {'Overstock'}>} Week&Material&[Supplier Loc]&[Customer Loc])

Count(DISTINCT {<Inventory_Position = {'NoDemand'}>} Week&Material&[Supplier Loc]&[Customer Loc])

Skewness formula as follows:

=Skew(DISTINCT {<Inventory_Position = {‘OOS'}>} Week&Material&[Supplier Loc]&[Customer Loc])

Skew(DISTINCT {<Inventory_Position = {'Low Stock'}>} Week&Material&[Supplier Loc]&[Customer Loc])

skew(DISTINCT {<Inventory_Position = {'Intolerance'}>} Week&Material&[Supplier Loc]&[Customer Loc])

skew(DISTINCT {<Inventory_Position = {'Overstock'}>} Week&Material&[Supplier Loc]&[Customer Loc])

Skew(DISTINCT {<Inventory_Position = {'NoDemand'}>} Week&Material&[Supplier Loc]&[Customer Loc])

Re: Skew calculation

avkeep01 — Fri, 08 Jun 2018 10:40:43 GMT

Hi,

You can make your expressions a lot simpler if you write them like this:

Count(DISTINCT {<Inventory_Position = {"OOS","Low Stock","Intolerance","Overstock","NoDemand"}>} Week&Material&[Supplier Loc]&[Customer Loc])

And then calculate the skew over your aggregated counts.

SKEW (AGGR(Count(DISTINCT {<Inventory_Position = {"OOS","Low Stock","Intolerance","Overstock","NoDemand"}>} Week&Material&[Supplier Loc]&[Customer Loc]),Inventory_Position))

Re: Skew calculation

sunny_talwar — Fri, 08 Jun 2018 11:15:13 GMT

Not entirely sure what you are needing, but may be this

=Skew(TOTAL Aggr(

Count(DISTINCT {<Inventory_Position = {'OOS'}>} Week&Material&[Supplier Loc]&[Customer Loc])

+Count(DISTINCT {<Inventory_Position = {'Low Stock'}>} Week&Material&[Supplier Loc]&[Customer Loc])

+Count(DISTINCT {<Inventory_Position = {'Intolerance'}>} Week&Material&[Supplier Loc]&[Customer Loc])

+Count(DISTINCT {<Inventory_Position = {'Overstock'}>} Week&Material&[Supplier Loc]&[Customer Loc])

+Count(DISTINCT {<Inventory_Position = {'NoDemand'}>} Week&Material&[Supplier Loc]&[Customer Loc])

, Inventory_Position))

Re: Skew calculation

bushpalaamarnat — Fri, 08 Jun 2018 12:38:15 GMT

Hi Sunny,

Your formula actually worked. Thank you for the information.

I am trying to get average\ skewness of inventory_positions

Re: Skew calculation

sunny_talwar — Fri, 08 Jun 2018 12:39:58 GMT

I am trying to get average\ skewness of inventory_positions

It worked? and you still trying to get average\skewness? You mean you also need average? may be this

=Average(TOTAL Aggr(

Count(DISTINCT {<Inventory_Position = {'OOS'}>} Week&Material&[Supplier Loc]&[Customer Loc])

+Count(DISTINCT {<Inventory_Position = {'Low Stock'}>} Week&Material&[Supplier Loc]&[Customer Loc])

+Count(DISTINCT {<Inventory_Position = {'Intolerance'}>} Week&Material&[Supplier Loc]&[Customer Loc])

+Count(DISTINCT {<Inventory_Position = {'Overstock'}>} Week&Material&[Supplier Loc]&[Customer Loc])

+Count(DISTINCT {<Inventory_Position = {'NoDemand'}>} Week&Material&[Supplier Loc]&[Customer Loc])

, Inventory_Position))

Re: Skew calculation

bushpalaamarnat — Fri, 08 Jun 2018 13:07:18 GMT

Thank you Sunny! it worked.

Re: Skew calculation

sunny_talwar — Fri, 08 Jun 2018 13:09:51 GMT

You marked your own response as correct ... did you want to mark one of my responses as correct?

Re: Skew calculation

bushpalaamarnat — Fri, 08 Jun 2018 13:13:45 GMT

Hi Sunny, you got that correct. i have close this skew thing today. then go home.

sorry if it was lots of work for you.