Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
sabmaldun
Contributor II
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
Sue_Macaluso
Community Manager
Community Manager

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
nilkanthraval
Contributor
Contributor

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