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