Discussion Board for collaboration on QlikView Scripting.
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.
Go to Solution.
You can use the fractile function to calculate the quartile values: fractile(Amount,.25).