Discussion Board for collaboration related to Creating Analytics for QlikView.
Hi team! Been slamming my head into my keyboard all day trying to figure out how to even start with a problem I have...
I have a cost field for many parts over many months. My goal is to create a new field within the load that shows what percentage of the parts' cost is for that month.
For example, I'm looking to create the new_percentage field below via the load:
The reason I need to create the percentage this way is to apply the percentage to another field (extra_cost) and add that weighted average back to the original cost to create adjusted_cost.
I would greatly appreciate any feedback anyone has to offer! I think this should be a simple work around, but I just cannot seem to wrap my head around what needs to be done.
Go to Solution.
May be this
Left Join (Table)
Sum(cost) as TotalCost
Group By month_year;
Num(cost/TotalCost, '##.##%') as new_percentage
DROP Table Table;
View solution in original post
Will u able to provide the logic behind?
I have seen the output you want, but i didn't follow. Perhaps try this way
Avg(cost) as percentile
RESIDENT PartData group by part_number, month_year;
I think this is exactly what I need to do. Thank you very much, Sunny! Very helpful!