topic Re: Counting Days in QlikView

Counting Days

Wed, 22 Aug 2012 20:49:52 GMT

When I select a Week in my document, the number of days in that week are highlighted only if there is data for those days. For example, a week has seven days but if my selection only contains data for 6 days, the count is 6. I want to be able to count the number of calendar days in a selection, regardless of presence of data. So, if I select a month I want to count 30, 31, or 28 days. Even if there are days missing data.

Can I do that?

Brian Summ

Re: Counting Days

sebastiandperei — Wed, 22 Aug 2012 21:30:46 GMT

Hi Brian.

It depends on the schema you have created. Do you have a Calendar Table?

If you have it, you could count (distinct Date_Field)

If you don't have it, try with

max(Date_Field)-min(Date_Field)

Date_Field must be in date format, not timestamp.

Re: Counting Days

Mon, 27 Aug 2012 19:45:12 GMT

Hi Sebastian,

Thanks for the help. I have tried the count function. Trouble is it only counts selected days if there is data. I want to count all selected days, regardless of presence of data.

Regards,

Brian

Re: Counting Days

prodanov — Mon, 27 Aug 2012 20:33:52 GMT

You must create a Calendar table and use Set analysis at MIn and Max function. Like that: max({1<week=,week={$(#=only(week))}>} date)

Re: Counting Days

sebastiandperei — Tue, 28 Aug 2012 11:31:37 GMT

Did you have tried the second suggest i sent?

Please, read all!

max(Date_Field)-min(Date_Field)

Re: Counting Days

Tue, 28 Aug 2012 14:27:17 GMT

Haven’t tried it yet. Thanks though.