Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

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
Highlighted
MVP
MVP

@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
Highlighted
MVP
MVP

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

Screenshot 2020-10-17 225147.png

View solution in original post

Highlighted
Contributor III
Contributor III

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