Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Change your expression so that records without a value won't be counted: count({<MyAmount={'*'}>} MyDate)
Change your expression so that records without a value won't be counted: count({<MyAmount={'*'}>} MyDate)
Thanks!