Quartiles Bucketing based on measure to create dimension column

[CK_WAKE]

Hi There,

I have a numerical column called amount, which contains random numbers. I want to use Quartiles bucketing, such as Q1, Q2, Q3 and Q4, as a dimension. I appreciate your help on this.

Thanks.

[steeefan]

It's unclear how your column that contains random numbers relates to dates that can be translated into quarters.

If you somehow also have a column that contains a date, try this:

'Q' & Ceil(Month(Date)/3) AS Quarter

[CK_WAKE]

Hi There, Sorry If i have confused you. It a numerical column called amount and the numbers are random. I want to create 4 buckets example: Quartile1: values between 0 - 120k, Quartile 2: 120K to so on. Just like Box plot or somthing like qcut in python pd.qcut(df['amount'],4).
It is nothing to do with date or quarter.

[CK_WAKE · Accepted solution]

Hi There, To achieve below query, i used the solution provided in this link and it worked.
How to distribute values into quartiles evently? - Qlik Community - 1344684