Discussion board where members can get started with QlikView.
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 thisYear,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.