Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

count calendar days

Hi guys,

I'd like calculate dinamycally count of calendar days.

Count({$<MYear={'$(=MonthName(max(MYear)-2))'}>} DISTINCT oDate)

In this case I get only count of collection days.

I have idea to add inline load by MYear and Ndays

Jun 2013, 30 and so on.

Who can suuggest maybe more professional issue.

Thanks,

3 Replies
Anonymous
Not applicable
Author

inline load didn't help me.

I need your suggestions.

Regards,

CELAMBARASAN
Partner - Champion
Partner - Champion

Could you explain the issue in detail?

Regards,

Celambarasan

Anonymous
Not applicable
Author

Hi,

I have the variable brand in deminsion. We collect some info.

I want to see how many we collect for yesterday, the day before yesterday (done) and

have average of collection in previous month and current month.

Other words, all collection for previous or cuurent month devide on count of previous or current month.

But some brands we don't collect each day.

My count of previous or current month is based on collection days, not calendar days.

Regards,