topic Re: Problem with network days in QlikView

Problem with network days

Tue, 07 Oct 2014 08:41:17 GMT

Hello!

I need not consider Saturdays and Sundays in my qv document. I have to calculate the data of yesterday, but when today is Monday i want to calculate data of Friday.

Thank you for your help!!!

Re: Problem with network days

simondachstr — Tue, 07 Oct 2014 08:45:55 GMT

Try using FirstWorkDate(Today(),2) maybe..

Re: Problem with network days

Tue, 07 Oct 2014 08:52:24 GMT

I have an object text:

=num(count({$<Day={$(=Max(Day)-1)},[name]={'BOOK'},[id]={1},[ip]={7}>}distinct id_2)

How do I add your function ?

Thank you @Martin Mahler

Re: Problem with network days

simondachstr — Tue, 07 Oct 2014 09:06:08 GMT

=num(count({$<Day={'$(=FirstWorkDate(Today(),2))'},[name]={'BOOK'},[id]={1},[ip]={7}>}distinct id_2)

Re: Problem with network days

Tue, 07 Oct 2014 09:51:41 GMT

Thanks but not work.

I want the data every day of "yesterday", when is tuesday->data monday, when is wednesday-> data tuesday and when is monday->data friday

Re: Problem with network days

simondachstr — Tue, 07 Oct 2014 09:56:30 GMT

What is the format of your Day field?

Re: Problem with network days

Tue, 07 Oct 2014 09:58:54 GMT

Script Editor sql:

datepart(dd,table_pp.date_reg) AS 'Day',

Re: Problem with network days

simondachstr — Tue, 07 Oct 2014 10:26:52 GMT

Can you be more specific - what does a typical record look like? 01/10/2014? 28 Jan?

Re: Problem with network days

Tue, 07 Oct 2014 10:28:48 GMT

Of course.

Example:

07/10/2014 10:04:53

DD/MM/YYYY h:mm:ss

Re: Problem with network days

simondachstr — Tue, 07 Oct 2014 10:44:03 GMT

You could use some complex set analysis here, but I stronlgy recommend to you to load an additional date field in the script

Date(Date#(datepart(dd,table_pp.date_reg),'DD/MM/YYYY HH:MM:SS'),'DD/MM/YYYY') AS Date

to get the following format instead: 07/10/2014

Then, use this field in your set analysis:

=num(count({$<Date={'$(=FirstWorkDate(Today(),2))'},[name]={'BOOK'},[id]={1},[ip]={7}>}distinct id_2)

Re: Problem with network days

Tue, 07 Oct 2014 11:26:11 GMT

Thanks but not work.

Re: Problem with network days

Wed, 08 Oct 2014 05:44:36 GMT

More ideas???

Re: Problem with network days

simondachstr — Wed, 08 Oct 2014 08:58:30 GMT

FirstWorkDate(today(),2)) will give you your desired date. Now your issue is not getting the right work date, but correctly applying the set analysis expression to your [Day] field.

I've suggested two options based on the information that you have made available, which are working in my local test example, but apparently do not work in your case.

The only way now to help you is if you could upload a sample qvw file of your data.

Re: Problem with network days

Wed, 08 Oct 2014 11:32:50 GMT

Sorry, but i can`t. do that

I've did this:

=if(DayW<>'Monday',num(count({$<Day={$(=Max(Day)-1)},[name]={'BOOK'},[id]={1},[ip]={7}>}distinct id_2),'#.##0,00'),num(count({$<Day={$(=Max(Day)-3)},[name]={'BOOK'},[id]={1},[ip]={7}>}distinct id_2),'#.##0,00')

But when is 02/10/2014 or 01/10/2014 the result is -, what is the problem?

Thank you!!!

Re: Problem with network days

Thu, 09 Oct 2014 06:36:08 GMT

Any ideas?

Thank you.