Discussion board where members can get started with Qlik Sense.
I am needing again your help on my project.
I need to get the percentage of CRITERIA per week and I am having trouble creating formula.
can someone help me what part of my formula needed modification.
see attached for the RAW file.
Go to Solution.
I am not sure that if you are trying to sum "plan_hours" and get a percentege over a week by Criteria. If that so, your expression on pivot table should be like this:
Sum(plan_hours)/sum(total <Fiscal_Week> plan_hours)
Can you give a example with numbers from your excel please!
CrossTable(hours, value, 1)
FROM [lib://downloads/PERCENT PER CRITERIA.xlsx]
(ooxml, embedded labels, header is 1 lines, table is Sheet2);
Sum(value)/sum(total <Fiscal_Week> value)
I have attached a new RAW file.
where below are not a field but a result from the expression.
how do I edit my formula or script using the attached data.
I have made some modification with your expression, instead of plan hours I change it to Lot_id and the result is what I am looking for.
Count(LotID)/Count(total <Fiscal_Week> LotID)