Finding if a row exists in a table

Mon, 07 Dec 2015 03:40:37 GMT

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

topic Finding if a row exists in a table in QlikView

Finding if a row exists in a table