topic Current selections date counter in QlikView

Current selections date counter

Thu, 31 Mar 2011 12:22:49 GMT

Hey Guys,

I'm trying to make a Gauge chart , formated as LED display , to give a counter of the date range selected.

So on my page I have a cyclic list box, with date group. I want to write an expression for this LED that states, count days in date range selected

Can anyone help please ?

Thanks

Anne

Thu, 31 Mar 2011 13:00:53 GMT

max(Date)-min(Date))+1

Hi Guys the above seems to work !!!

But I'd like it to count weekdays only !

Can you please please help ?

Thanks

Thu, 31 Mar 2011 13:37:05 GMT

Hi Anne,

You can use the Network days function which will give the number of working days between start and end date

Thu, 31 Mar 2011 13:54:58 GMT

Hi XXX

I have tried

=NetWorkDays(GetFieldSelections(max(Date)),GetFieldSelections(min(Date)))

As i wish to count the number of work days between my selected dates, but the above is not working ,

Can you please help ?
Thanks

Thu, 31 Mar 2011 14:09:45 GMT

=NetWorkDays(min(Date),max(Date))

OMG So Sorry , very easy , I'm not the brightest spark in the box!!!!!

Thanks for your help alls good now