Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
edg
Partner
Partner

StDev Function results only displaying in totals

I need to use the StDev function to display a value across multiple rows of data using two dimensions. However, the value I need only shows up in the total.

I've tried the following, including using nodistinct in the aggr function:

stdev(aggr(count([X]),[Month_Year]))

stdev(aggr(count([X]),[Month_Year], [Product Name]))

Product NameMonth_YearCount of XSt. Dev
Product11-2021867-
Product12-2021842-
Product13-20211043-
Product14-2021946-
Product15-2021886-
Product16-2020686-
Product16-2021189-
Product17-2020705-
Product18-2020723-
Product19-2020807-
Product110-2020863-
Product111-2020771-
Product112-2020804-
Totals  203
    

 

This is how it should display:

Product NameMonth_YearCount of XSt. Dev
Product11-2021867203
Product12-2021842203
Product13-20211043203
Product14-2021946203
Product15-2021886203
Product16-2020686203
Product16-2021189203
Product17-2020705203
Product18-2020723203
Product19-2020807203
Product110-2020863203
Product111-2020771203
Product112-2020804203

 

On a side note, the function works in another table without the date and the following syntax.

STDev(aggr(count(distinct [X]), [Month_Year], [Product Name]))

 

1 Reply
sunny_talwar

Try this

StDev(TOTAL Aggr(Count(DISTINCT [X]), [Month_Year], [Product Name]))