Master Calendar, ignore days with no data

[#1]

Hi,

Im using the master calendar made by rwunderlich, pls see below link.

http://community.qlik.com/thread/66717

It's been working greatfor me, until now.

I need to calculate monthly averages, and the calendar seems to include all dates (weekends and dates with no data) which messes upp the day count, since im only interested in the dates with data.

Any idea how to work around this issue?

Kind Regards,

Olle

[Gysbert_Wassenaar · Accepted solution]

Change your expression so that records without a value won't be counted: count({<MyAmount={'*'}>} MyDate)

[#3]

Thanks!