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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
coloful_architect
Creator II
Creator II

how to use a standard deviation function in qlik sense

hi guys,

Trying to use stdev to address a business question. I have fields: customers, suppliers, sales. 

Each customer could have several suppliers. Trying to find out which customer has suppliers with a more dispersed pattern like supplier A 25%, supplier B 25%, supplier C 25% and supplier D 25%

Not like supplier A 98%, supplier B 2%.

I believe a relatively small number of stdev would shred some lights.

but I am now wrapping my head around using the function at a table.

how I can use stdev and apply with a set expression to filter out sales less than 0 ?

I want to insert into a table with this format 

customer supplierunitsStd value

 

or pivot table

customer supplier A, supplier B, supplier C,..... units, Std value 

 

1 Solution

Accepted Solutions
Coloful_Black
Contributor III
Contributor III

slight tweak by adding supplier

=stdev(
aggr(sum([Pack Units]), [Business Name],Supplier))

View solution in original post

2 Replies
coloful_architect
Creator II
Creator II
Author

I tried this but end up with blank cells....

StDev(aggr(sum([Pack Units]), distinct Manufacturer))

coloful_architect_0-1633575667916.png

 

 

Coloful_Black
Contributor III
Contributor III

slight tweak by adding supplier

=stdev(
aggr(sum([Pack Units]), [Business Name],Supplier))