Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Current selections date counter

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

1 Solution

Accepted Solutions
Not applicable
Author

=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



View solution in original post

4 Replies
Not applicable
Author

=(

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





Not applicable
Author

Hi Anne,

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

Not applicable
Author

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

A



Not applicable
Author

=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