Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Andrea
You may find NetWorkDays / FirstWorkDate / LastWorkDate functions useful
Lukasz
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.
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
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.
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