Build Quartiles per Month in the Load Script

[sabmaldun]

Hello all,

I hope anyone can help me.

I have to build quartiles based on the sum(Partsales) for each Dealer per month and market.

I have to do it in the load script, because based on it I have to calculate Averages later on

My table looks like this
Year,
Month,
Partsales,
DealerID,
market,
Rank

I have already build ranks for the dealer per month and market based on Partsales, because I thought it helped for calculating the quartiles.
something like this

If rank <=0.4*total rankcount of that month then quartile1,

If rank >=0.4*total rankcount of that month then quartile2

Does anyone know how the exact script looks like for the solution. I cannot achieve it.
Thank you.

Kind regards

[Sue_Macaluso]

Hi, Is this for QlikView or Sense? I would like to move it to the appropriate product forum. This one is typically non product discussions.

[nilkanthraval]

Please share the data and expected output in excel file so that i can think upon it.