topic Build Quartiles per Month in the Load Script in QlikView

Build Quartiles per Month in the Load Script

sabmaldun — Sat, 16 Nov 2024 21:20:50 GMT

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

Re: Build Quartiles per Month in the Load Script

Sue_Macaluso — Tue, 26 Feb 2019 18:45:34 GMT

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.

Re: Build Quartiles per Month in the Load Script

nilkanthraval — Tue, 02 Apr 2019 09:33:07 GMT

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