Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Stars
Creator
Creator

NUM function with FRACTILE instead of AVG

I am trying to apply numbering formats to my columns in a table.  It works perfectly in one column (mean), but doesn't work in the column next to that (Q1).  The mean column uses an AVG expression, while the Q1 column uses a FRACTILE expression.  Could this be doing something?  Attached are a picture of my table right now and then of the expressions I'm using for the mean and Q1 column.  I figure it's a simple mistake somewhere, but I can't find it.  Please help!  Thank you!

 

Avg vs Fractile.JPG

Mean vs Q1.JPG

1 Solution

Accepted Solutions
Kushal_Chawda

@Stars  check that number formatting option for measure Q1 is "Measure expression"

Screenshot 2020-10-17 225147.png

View solution in original post

2 Replies
Kushal_Chawda

@Stars  check that number formatting option for measure Q1 is "Measure expression"

Screenshot 2020-10-17 225147.png

Stars
Creator
Creator
Author

YOU ARE BRILLIANT!!!!  Thank you.  I knew I was missing something ridiculous.  THANK YOU SO MUCH!