Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
What are you expecting as your answer maybe you are using the wrong function.
What are you expecting as your answer maybe you are using the wrong function.
Hi,
Sorry, I figured I need to add data as dimension and change from there.