Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
nguyvie
Contributor
Contributor

Skewness value doesn't display until one dimension value is selected

Hi everyone. The app I'm currently developed has a chart  with measure as turnover and dimension as age_group (display in the bottom below). We tried to calculate the skewness of the chart (turnover and age_group) over the another dimension, in this case department_name.  I also create a table (on top right, with dimension as department_name, measure as skewness) to display the skewness  over different departments 

Skewness formula:  =Skew( Aggr( sum( turnover), age_group))

doesn't displaydoesn't display

For some reason, the  skewness value in the table doesn't get displayed (grey color with  hyphen -), until one specific department is selected (picture below)

test-skew-doesnt-display-until-selected.JPG

Is there anyway to display  all the skewness for each department like in the first picture (so that the user can see all of the skewness instead of having to select each department to see skewness value)?

Labels (1)
0 Replies