Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

akuttler
Contributor

Average Weekly for Specific Year

Hello,

I keep getting an error for the expression:

(Sum({<ITEMTYPE={'C'},Year={2017}>}Trans))/(Count(Distinct DATE({<Year={2017}>}WeekYear)))

Fields names ITEMTYPE= 'C' refers to Charges

Trans =Transactions


I am trying to get the Average Weekly Charges for 2017.

Thanks in advance.

1 Reply
OmarBenSalem
Esteemed Contributor

Re: Average Weekly for Specific Year

what is this DATE doing here?

Count(Distinct DATE({<Year={2017}>}WeekYear)

Community Browser