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

Announcements
Discover how organizations are unlocking new revenue streams: Watch 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))