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

Fractile function returning invalid dimension

Hi,

I have a table as below

ItemPrice
Apple from North1
Apple from South2
Apple from East3
Apple from West4

I have uploaded this data into my app. I wanted to show in my app the 75 percentile. I found a function Field=Factile(item,0.75) but when I apply this, the table will show "Invalid dimension".

Documentation at https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/ChartFunctions/StatisticalAggreg... seems very direct but I not sure if I did it correctly. Please help?

1 Solution

Accepted Solutions
sibusiso90
Creator III
Creator III

What are you expecting as your answer maybe you are using the wrong function.

View solution in original post

2 Replies
sibusiso90
Creator III
Creator III

What are you expecting as your answer maybe you are using the wrong function.

wuming79
Creator
Creator
Author

Hi,

Sorry, I figured I need to add data as dimension and change from there.