This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
Hello to all
Hoe can calculate the average for each partcode base on PartL3 column?
axample in attached 🙂
thanks to all
@lukeert19 just change Sums to Counts
Count(pcs)/Count(TOTAL <PartL3> pcs)
View solution in original post
@lukeert19 May be this
Count(DISTINCT TOTAL <PartNumber> PartNumber)
Try this one
Sum(Pcs)/sum(total <PartL3> Pcs)
thanks for replay @chooco_co
my mistake sorry, I can't use sum() function because PCS column is a formule --> count(pcs) and I can't put this formula into sum(count(pcs)) 😞
hello @sunny_talwar and @chooco_co thanks a lot for your time.
by using the formula above is possible to calculate the avg based on PartlL3 field that it's good, fist report done, thanks a lot again
I have only last question about other similar report, I have attached a picure where in table I have 3 calculated columns
coloumn: qty consumed --> done with Count(pcs)
total P/N repaired: based on teh first column [partNumber] how can show the result like in the picture?
avg column based on qty consumed and total P/N Repaired -->how can calculate the result like in the picture?
Count(TOTAL <PartNumber> PartNumber)
hello @sunny_talwar I have already tried but the number shown from qlik isn't real, I need to use one formula like below
Count(distinct <ID> PartNumber)
but I don't know how I can correct this formula 😞