topic Re: count calendar days in QlikView

count calendar days

Anonymous — Thu, 18 Jul 2013 12:58:02 GMT

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,

Anonymous — Thu, 18 Jul 2013 13:38:18 GMT

inline load didn't help me.

I need your suggestions.

Regards,

CELAMBARASAN — Thu, 18 Jul 2013 13:52:19 GMT

Could you explain the issue in detail?

Regards,

Celambarasan

Anonymous — Thu, 18 Jul 2013 14:00:58 GMT

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,