Thanks Stephen for the response.
But that is not what I was looking for. Sorry for not being clear.
On the basis of past data, I want the projection to be split to the State, District and Product level.
for the 1st table to be created, I would have used (Volume_plan of S1) * (Volume_sold of S1&D1 / Volume_Sold of S1) = Volume_plan of S1&D1
for the 2nd table to be created, I would use the above formula to (Volume_plan of S1&D1)*(Volume_sold of S1&D1&P1)/Volume_sold of S1&D1)
I am not sure of how these excel SUMIF and CONCATENATE operations are to be done in qlikview.
Volume_plan of S1 = Sum(TOTAL<State> Volume_plan)
Volume_sold of S1&D1 = Sum(TOTAL<State, District> Volume_sold)
Volume_Sold of S1 = Sum(TOTAL<State> Volume_sold)
So, the plan would be: Sum(TOTAL<State> Volume_plan) * Sum(TOTAL<State, District> Volume_sold) / Sum(TOTAL<State> Volume_sold)
Hopefully you should be able to work out the rest yourself?
Stephen Redmond is author of QlikView for Developer's Cookbook
Follow me on Twitter: @stephencredmond
Thanks a lot.
But just before your response was received, I was going through the reference manual and found aggr().
I used Volume_sold of S1&D1 as AGGR NODISTINCT SUM(Volume_plan, State, District)
On similar lines, remaining formulae also worked out
This seems to work fine too.
Could you please tell me which one is better to use?
Thanks for the response Somenath
Checked the logic. Its actually fine.
Attaching the final file just for the benefit of the community in case someone needs it.
Thanks again for the response.
Test_final.qvw 133.5 K