Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

How to do Quartiles in the script

Good day,

I´ve this app that has the following columns USERID,monthtx and amounttx which has the amount of money spend on any given month.

so my goal is categorize or organize with quartils the user upon the amount they spend throught out six month period which is a data range that i have.

How do i do that.?

the total rows is aprox 12 millons..

any help will be appreciated.

JuanD

1 Solution

Accepted Solutions

Re: How to do Quartiles in the script

You can use the fractile function to calculate the quartile values: fractile(Amount,.25).


talk is cheap, supply exceeds demand
1 Reply

Re: How to do Quartiles in the script

You can use the fractile function to calculate the quartile values: fractile(Amount,.25).


talk is cheap, supply exceeds demand
Community Browser