counting of no. of days

[Anonymous]

Hello All,

I am counting number of days with networkdays() function.

Example: networkdays(min(orderdate), max(orderdate))

but this function also counting no. of days from those month as well which are not available for the selection.

I want to count only those days in which order has been given.

Is their any alternate of networkdays() function?

Regards,

Balraj Ahlawat

[Anonymous]

But it not required in this case

[tresesco]

Create a sample qvw and explain the expected output there, that would help us understand your case.

[#4]

Hi Balraj,

Won't it be easier to load a date table into your QlikView model with these type of things pre-defined. Like workday = Monday - Friday plus public holiday flags etc. We use it this way around and it makes life much easier.

Regards,
Marius

[#5]

I am not sure if I can understand your scenario. But if you wish to count or sum some variable onlywhen orders were sent, you could use set analysis. For example

{$<

order_value={'>0'}

>}