topic Re: Concat Function in QlikView

Concat Function

nevilledhamsiri — Sun, 29 Apr 2018 14:26:18 GMT

Hi Sunny,

Appreciate if you could refer this & help me out. This was developed with your former information that I had received!

I have applied the said function to bring back the reasons to the Pivot table from the mapping table which reason should always possible only if the the type of visit equal to ''Late day visit'' (Date to visit<> date visited). Please see what mistake I have done as I do not get it appear in cases where above criteria is met.

SUM({<[Person Visited]={'Neville','Vernon','Mahesh','Iresha','Sineka'},[Branch visited]={'Thanamalwilla','Angunakolapelessa','Godakawela','Eheliyagoda','Kuruwita','Balangoda','Palebedda','Middeniya','Embilipitiya','Kalawana','Kiriella','Pelmadulla','Kahawatta'},Fixed_Month={'Jan'},Type_Of_Visit={'Late_Date_Visit'}>} Aggr( Concat([Reason For late]),[Branch visited],[Person assigned for Visit],[Person Visited],Fixed_Month))

Many Thanks

Neville

Re: Concat Function

nevilledhamsiri — Mon, 30 Apr 2018 03:39:03 GMT

Please refer the Ammended attachment & as per the requested expression.

I hope to update the mapping table monthly with remarks only for late visit so the reason for late visit to be picked every month if there is a ate visit.

SUM({<[Person Visited]={'Neville','Vernon','Mahesh','Iresha','Sineka'},[Branch visited]={'Thanamalwilla','Angunakolapelessa','Godakawela','Eheliyagoda','Kuruwita','Balangoda','Palebedda','Middeniya','Embilipitiya','Kalawana','Kiriella','Pelmadulla','Kahawatta'},Fixed_Month={'Jan'},TYPE_OF_VISIT={'LATE_DATE_VISIT'}>} Aggr( Concat([Reason For late],','),[Branch visited],[Person assigned for Visit],[Person Visited],Fixed_Month))

Re: Concat Function

nevilledhamsiri — Thu, 03 May 2018 17:15:00 GMT

Would you mind looking in to this please

Regrds

Neville