topic Re: concat two firstsortedvalue expression. in QlikView

concat two firstsortedvalue expression.

Anonymous — Thu, 07 Aug 2014 17:23:35 GMT

Hi,

I want to combine two expression come as a single filed.

concat( FirstSortedValue([DWH_IM_MONTH],-AGGR(SUM(SALES_IM_QTY),DWH_SKU_REF_NO,DWH_IM_MONTH,DWH_IM_DATE_YEAR)) , FirstSortedValue([DWH_IM_DATE_YEAR] , -AGGR(SUM(SALES_IM_QTY),DWH_SKU_REF_NO,DWH_IM_MONTH,DWH_IM_DATE_YEAR)),'&')

can someone tell me whats wrong with this Formula.

Re: concat two firstsortedvalue expression.

jerem1234 — Thu, 07 Aug 2014 17:32:30 GMT

For something like that, you don't want to use the concat function. The concat function will cycle through a field and concat all the values together. What you want to do is combine the two expressions into one value. Try:

=FirstSortedValue([DWH_IM_MONTH],-AGGR(SUM(SALES_IM_QTY),DWH_SKU_REF_NO,DWH_IM_MONTH,DWH_IM_DATE_YEAR)) & '&' & FirstSortedValue([DWH_IM_DATE_YEAR] , -AGGR(SUM(SALES_IM_QTY),DWH_SKU_REF_NO,DWH_IM_MONTH,DWH_IM_DATE_YEAR))

Hope this helps!

Re: concat two firstsortedvalue expression.

Anonymous — Fri, 08 Aug 2014 08:56:41 GMT

Thank you so much Jermiah, worked absolutely fine, Really appreciate your quick response.