Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Non working days in Set Analysis

Hello everybody,

Please help with making formula in visualization:

I need to take data for one parameter only for working days in Russia. But I have non inadequate results.

So I have bellow formula:

=COUNT([OBJKEY.UNIQ.FORCOUNT])/count(BELNR_HST)/networkdays(date($(vL.PeriodStart),'DD.MM.YYYY'),date(today(),'DD.MM.YYYY'),'01.01.2018','02.01.2018','03.01.2018','04.01.2018'

,'05.01.2018','06.01.2018','07.01.2018','08.01.2018','23.02.2018','08.03.2018','09.03.2018','30.04.2018','01.05.2018','09.05.2018',

'11.06.2018','12.06.2018','04.11.2018','05.11.2018','31.12.2018')

If I have such formula: =COUNT([OBJKEY.UNIQ.FORCOUNT])/count(BELNR_HST),

I have normal data, but it crucial to remove holidays from final results

Thanks in advance

1 Solution

Accepted Solutions
Highlighted
Champion III
Champion III

Re: Non working days in Set Analysis

May create a variable vHolidays and add those holiday dates like

SET vHolidays =

'01.01.2018','02.01.2018','03.01.2018','04.01.2018','05.01.2018',

'06.01.2018','07.01.2018','08.01.2018','23.02.2018','08.03.2018',

'09.03.2018','30.04.2018','01.05.2018','09.05.2018','11.06.2018',

'12.06.2018','04.11.2018','05.11.2018','31.12.2018';



= COUNT({<YourdateField = {"= networkdays(date($(vL.PeriodStart),'DD.MM.YYYY'),date(today(),'DD.MM.YYYY'), vHolidays)"} >} [OBJKEY.UNIQ.FORCOUNT])

   /

   COUNT({<YourdateField = {"= networkdays(date($(vL.PeriodStart),'DD.MM.YYYY'),date(today(),'DD.MM.YYYY'), vHolidays)"} >} BELNR_HST)

View solution in original post

2 Replies
Highlighted
Champion III
Champion III

Re: Non working days in Set Analysis

May create a variable vHolidays and add those holiday dates like

SET vHolidays =

'01.01.2018','02.01.2018','03.01.2018','04.01.2018','05.01.2018',

'06.01.2018','07.01.2018','08.01.2018','23.02.2018','08.03.2018',

'09.03.2018','30.04.2018','01.05.2018','09.05.2018','11.06.2018',

'12.06.2018','04.11.2018','05.11.2018','31.12.2018';



= COUNT({<YourdateField = {"= networkdays(date($(vL.PeriodStart),'DD.MM.YYYY'),date(today(),'DD.MM.YYYY'), vHolidays)"} >} [OBJKEY.UNIQ.FORCOUNT])

   /

   COUNT({<YourdateField = {"= networkdays(date($(vL.PeriodStart),'DD.MM.YYYY'),date(today(),'DD.MM.YYYY'), vHolidays)"} >} BELNR_HST)

View solution in original post

Highlighted
Contributor III
Contributor III

Re: Non working days in Set Analysis

Thanks a lot!

It`s working

Have a nice day