topic Showing NetWorkDays in set analysis in QlikView

Showing NetWorkDays in set analysis

Thu, 03 May 2012 03:58:31 GMT

I'm very new to Qlikview and I'm trying to show the difference in days between two field names that have dates behind them, but I want to show it in NetWorkDays and I would like to show this as set analysis and don't know how to show this in a formula.

The fields names are ZSD_PIPELINE.ZZCFDT and ZSD_PIPELINE.ZZRQDT with the 2nd taken away from the 1st.

Thanks in advance.

Showing NetWorkDays in set analysis

jagan — Thu, 03 May 2012 07:35:53 GMT

Hi,

You can use NetWorkDays() to calculate working days, it excludes Saturdays and Sundays and given Holidays list.

networkdays (start:date, end_date {, holiday})

Returns the number of working days (Monday-Friday) between and including start_date and end_date taking into account any optionally listed holidays. All parameters should be valid dates or timestamps.

Examples:

networkdays ('2007-02-19', '2007-03-01') returns 9

networkdays ('2006-12-18', '2006-12-31', '2006-12-25', '2006-12-26') returns 8

Check this in Help file.

Regards,

Jagan.

Showing NetWorkDays in set analysis

magavi_framsteg — Thu, 03 May 2012 07:51:32 GMT

Hi jagan mohan.

You can (should) try and do this calculation in your load script instead of at runtime.

It will render better performance, both CPU and RAM-wise.

This is usually good practise, it will usually not affect file size since those <int> networkdays might already exist in other fields in your datamodel. Thus not adding more data to themodel, instead only linking to existing values already present.

Kind regards

Magnus Åvitsland

BI Consultant

Framsteg Business Intelligence Corp.

Showing NetWorkDays in set analysis

Thu, 03 May 2012 12:23:23 GMT

Hi Magnus

Sorry should have explained myself better I'm creating a weview for other users to see data from a predefined script taken from SAP and am unable to change it. So have to do any data manipulation within the tables I create.

I did this with the information Jagan posted NetWorkDays(ZSD_PIPELINE.ZZCFDT, ZSD_PIPELINE.ZZRQDT)

but only got back 0 values.

Thanks for your help.

Re: Showing NetWorkDays in set analysis

Tue, 19 Aug 2014 04:17:58 GMT

have you tried changing the fields around? networkdays works from start and counts to finish, rather than counting back from finish to start

end formula should be NetWorkDays(ZSD_PIPELINE.ZZRQDT,ZSD_PIPELINE.ZZCFDT) if I read your question correctly

Re: Showing NetWorkDays in set analysis

avinashelite — Tue, 19 Aug 2014 04:43:49 GMT

try like this

NetWorkDays(Min(ZSD_PIPELINE.ZZCFDT), Max(ZSD_PIPELINE.ZZRQDT))

Re: Showing NetWorkDays in set analysis

jagan — Tue, 19 Aug 2014 05:09:45 GMT

Hi,

Try changing the fields like below

NetWorkDays(ZSD_PIPELINE.ZZRQDT, ZSD_PIPELINE.ZZCFDT)

Syntax:

networkdays (start:date, end_date {, holiday})

Regards,

Jagan.