topic Re: Re: Table/ Selection in QlikView

Table/ Selection

Thu, 06 Feb 2014 21:38:49 GMT

Hi, I'm new with Qlikview.

I'm trying to make a table where I count working days of 2013 between two dates.

I want to show only records where I have days of 2013, as this example:

- from 01/02/2011 to 01/06/2011: i dont' visualize

- from 01/02/2011 to 01/06/2013: I visualize

- from 01/06/2013 to 06/07/2013: I visualize

ecc.

Can you help me with the example attached please?

Any suggestions greatly appreciated.

Andrea

Re: Table/ Selection

Thu, 06 Feb 2014 21:52:09 GMT

Hi Andrea

You may find NetWorkDays / FirstWorkDate / LastWorkDate functions useful

Lukasz

Re: Table/ Selection

brindlogcool — Thu, 06 Feb 2014 21:56:30 GMT

You can modify the expression as

=If(Year([End Date])>=2013,(rangemax(rangemin(makedate(2013,12,31),[End Date])-rangemax(makedate(2013,1,1),[Start Date]),0)+1) ).

there might be other ways using set analysis.

Re: Table/ Selection

Fri, 07 Feb 2014 20:42:16 GMT

Hi! Thank you for your help!

Is there another way to do this?

I try this modification, but I find these issues:

1) the fields without 2013 data are not hidden;

2) when End Date is blank, I expected to use 31.12.2013 as date. Using this modification doesnt work this part.

For example from 01.01.2011 to "-" , should be considered as from 01.01.2013 to 31.12.2013;

Would you be so kind to help me to find a solution?

I really appreciate any help you can provide me.

Regards,

Andrea

Re: Re: Table/ Selection

brindlogcool — Fri, 07 Feb 2014 21:03:00 GMT

For

1) the fields without 2013 data are not hidden; -

--- It is working fine. Attached the file for your reference.

2) when End Date is blank, I expected to use 31.12.2013 as date. Using this modification doesnt work this part.

For example from 01.01.2011 to "-" , should be considered as from 01.01.2013 to 31.12.2013;

---You have change the expression as it should be 31.12.2013 when the end date is null or

Change it at the load script as when the end date is null replace it with 31.12.2013.

Re: Re: Table/ Selection

Sun, 09 Feb 2014 12:06:16 GMT

Hi! Thank you for your help.

I'm new to qlikview, so maybe my questions may seem commonplace.

I'm trying to create the same graph only considering 2011 or 2012 or 2013 data. So I think I cant change the script as when the end date is null replace it with 31.12.2013.

How can I change my expression to replace null fields with 31.12.2011 or 31.12.2012 ecc as my necessities?

I would like to thank you for the time you have taken to update me on my question.

Regards,

Andrea