Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Read about Qlik’s Response to COVID-19 Read the Letter, Join the Group.
Highlighted
New Contributor II

Build Quartiles per Month in the Load Script

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

Labels (1)
2 Replies
Highlighted
Community Manager
Community Manager

Re: Build Quartiles per Month in the Load Script

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.
Sue Macaluso
Highlighted
New Contributor

Re: Build Quartiles per Month in the Load Script

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