Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Master Calendar, ignore days with no data

Hi,

Im using the master calendar made by Guru, 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

1 Solution

Accepted Solutions
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand

View solution in original post

Not applicable
Author

Thanks!