Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Sort the Concat function with 2 dimension

As we have sort the values of concat function with 1 dimension

Concat(DISTINCT RawDim, '|',Rowno)


Can we this using two dimension


I tried  this

Concat(DISTINCT RawDim, '|',Rowno)

but this gives incorrect result

2 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

Is Rowno a field name? Or do you mean RowNo()?

It would be much easier to help you if you provided more details. Its hard to diagnose and fix "incorrect result". The best would be a small qvw file containing sample data and the chart/table that illustrates the problem, along with the output you want.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
tresesco
MVP
MVP

You can actually write an expression for sort order, like:

Concat( Distinct SalesMan, '|' , Year*100+Num(Month))