Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want a calculation of consumed % for below table in qlik :
ENGG. | JOB SHEET | CONSUMED PART QTY | Consumed % |
AB | 1 | 2 | %(total sum of consumed part qty/total sum of jobsheet) |
ABB | 1 | 1 | %(total sum of consumed part qty/total sum of jobsheet) |
ABC | 1 | 4 | %(total sum of consumed part qty/total sum of jobsheet) |
ABCD | 1 | 5 | %(total sum of consumed part qty/total sum of jobsheet) |
DFFH | 1 | 1 | %(total sum of consumed part qty/total sum of jobsheet) |
DHSYC | 1 | 2 | %(total sum of consumed part qty/total sum of jobsheet) |
SXHS | 1 | 1 | %(total sum of consumed part qty/total sum of jobsheet) |
Total | 7 | 16 | %(total sum of consumed part qty/total sum of jobsheet) |
Hi @Ashutosh11 ,
Maybe this:
sum(CONSUMED PART QTY)/sum( TOTAL <JOB SHEET> CONSUMED PART QTY )
I hope it can helps.
Best Regards
Hi @Ashutosh11 ,
Maybe this:
sum(CONSUMED PART QTY)/sum( TOTAL <JOB SHEET> CONSUMED PART QTY )
I hope it can helps.
Best Regards