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?
