topic Re: Straight Table issue in QlikView

Straight Table issue

powerqlik — Thu, 30 Nov 2017 19:56:42 GMT

Hi everyone,

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!

Re: Straight Table issue

sunny_talwar — Thu, 30 Nov 2017 20:24:19 GMT

When you have multiple dates?

Do you want to see all? Use Concat

Do you want to see Max? Use Max

Do you want to see Min? Use Min

instead of using Only

and then to get the correct format, you can use Date() function to format like a date

Re: Straight Table issue

powerqlik — Thu, 30 Nov 2017 20:44:38 GMT

Awesome! The only problem now is that there are no spaces between the dates. Can you please modify my script so that there are spaces or | between dates (i.e. 11/1/2016 | 11/1/2017)

Re: Straight Table issue

sunny_talwar — Thu, 30 Nov 2017 21:08:02 GMT

May be this

Concat({<SetAnalysis>} [Effective Start], ' | ')

Re: Straight Table issue

powerqlik — Thu, 30 Nov 2017 21:40:30 GMT

Thanks as ALWAYS!