topic Non working days in Set Analysis in QlikView

Non working days in Set Analysis

ivanaksen — Mon, 06 Aug 2018 07:01:38 GMT

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

Re: Non working days in Set Analysis

vishsaggi — Mon, 06 Aug 2018 16:27:56 GMT

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)

Re: Non working days in Set Analysis

ivanaksen — Tue, 07 Aug 2018 06:29:25 GMT

Thanks a lot!

It`s working

Have a nice day