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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
marc_qlik
Contributor
Contributor

Stdev with missing data sets in Qlik sense

Hello,

I have a data set with 100 materials and with the corresponding number of pieces on a daily base. Now I want to calculate the stdev on a monthly base for each material. Problem is, that not for each month a data set exists  (s. example row 1).#

Can the formular be fixed?

Stdev(aggr(sum(pieces), [Material], [Month]

 

1. row: Stdev of 26,904 in Qlik with missing data sets for Apr, Jun, Aug and Oct.

2. row: Stdev as it should be 24, 772 with "0" instead od NULL

marc_qlik_0-1626443043241.png

 

Thank you

0 Replies