Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I use the following measure to calculate my percentages per Year/Month:
Count(distinct [PurchDoc])/count(total< [Year/Month] >distinct [PurchDoc])
I expected the pivot table to calculate the average of the percentages for each column in the totals. Yet when I compare the totals from Qlik Sense with the average I calculated in Excel there is a difference for one column (53% instead of 56%).
Why is this?
Hi,
The expression works well.
Here is the QVF.
Also the Screenshot.
Regards,
Kaushik Solanki
Can you try this:
Avg(Aggr(Count(distinct [PurchDoc])/count(total< [Year/Month] >distinct [PurchDoc]), [Year/Month], [Buying Channel]))
Hi,
Try this expression,
Avg(Aggr(Count(distinct [PurchDoc])/count(total< [Year/Month] >distinct [PurchDoc]),[Buying Channel]))
Regards,
Kaushik Solanki
I tried both expressions but it still displays an incorrect average of 53%.
Would you be able to share a sample?
No problem. See attachment.
Hi,
The expression works well.
Here is the QVF.
Also the Screenshot.
Regards,
Kaushik Solanki
Precisely, I think you might have just checked one expression and forgot to check mine. This one does seem to work:
Avg(Aggr(Count(distinct [PurchDoc])/count(total< [Year/Month] >distinct [PurchDoc]), [Year/Month], [Buying Channel]))
You're right. The expression works well. I was just implementing it in the wrong area. I thought it was to be inserted in the totals.