I was wondering if someone can help me solve a straight table issue. So currently I am displaying multiple columns in a straight table that's being feed from Excel. The problem I have is one of my expression is not displaying data when there are more than one rows in the respective column.
So basically I am trying to display a City and show each year there is a rent increase. For locations that have only one rent increase date, it's displaying properly in the "Base Rent Change" column. For locations that have multiple rent increases (i.e. Dec 2017, Mar 2018, Dec 2019), the field in Qlikview is coming up as blank.
Can anyone help to correct the Base Rent Expense Change column to display all rent increase dates? Please see attachment to make more sense. Thank you in advance!