Fractile function returning invalid dimension

[wuming79]

Hi,

I have a table as below

Item	Price
Apple from North	1
Apple from South	2
Apple from East	3
Apple from West	4

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?

[sibusiso90 · Accepted solution]

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

[wuming79]

Hi,

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