I have a table that looks like this:
I have a table that looks like this:
Name File FileRight StartDate FileRight EndDate
Alice A 1-1-2015 31-1-2015
Joyce A 1-1-2015 31-1-2015
Oliver A 1-1-2015 31-1-2015
Alice A 1-2-2015 31-3-2015
Joyce A 1-2-2015 31-3-2015
It shows from a certain period of time whether a user has a right to a certain file. If a row exists, it mean a user has the right. For example, Oliver has the right to access file A from 1-1-2015 to 31-1-2015. However, Oliver no longer has access right to File A from 1-2-2015 to 31-3-2015. To indicate this, I would like to add a new column (see below) to the table using either calculated dimensions or expressions in table properties. Could anyone provide some advice on how to do this? I am quite new to Qlikview so some explanation would be appreciated! Thanks.
Name File FileRight StartDate FileRight EndDate Has File right changed?
Alice A 1-1-2015 31-1-2015 No
Joyce A 1-1-2015 31-1-2015 No
Oliver A 1-1-2015 31-1-2015 Yes
Alice A 1-2-2015 31-3-2015 No
Joyce A 1-2-2015 31-3-2015 No