topic Networkdays in set analysis in QlikView

Networkdays in set analysis

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi there,

i want to calculate the count of a given field "Commande client" with some criterias and if the difference of a date filed "Date de creation" from today is bigger than 5 days.

I am using set analysis but i cannot intergrate networkdays function in it and make it work.

count({$<[Délai statut 6 - Statut 3]={"999999"},[Regroupement]={"PRO","FIL"}>}[Commande client])

I would like to add in the expression the following: networkdays(([Date de création]),today())">5" but i need help with the syntax.

Thank you for your help,

Lawrence

Re: Networkdays in set analysis

sunny_talwar — Sun, 26 Feb 2017 19:36:40 GMT

May be this:

Count({$<[Délai statut 6 - Statut 3] = {"999999"}, [Regroupement] = {"PRO","FIL"}, [Date de création] = {"=NetWorkDays([Date de création], Today()) > 5"}>} [Commande client])

Re: Networkdays in set analysis

Anonymous — Mon, 27 Feb 2017 08:05:15 GMT

Thank you very much,

this works fine.