Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

shweta2608
Contributor

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
MVP
MVP

Re: Sort the Concat function with 2 dimension

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
MVP
MVP

Re: Sort the Concat function with 2 dimension

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

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

Community Browser