Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
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.
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