Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

Current selections date counter

=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



4 Replies
Not applicable

Current selections date counter

=(

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

Current selections date counter

Hi Anne,

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

Not applicable

Current selections date counter

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

Current selections date counter

=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



Community Browser