topic Re: Sorting Data in Text Box in QlikView

Sorting Data in Text Box

Wed, 13 May 2015 15:18:31 GMT

Hi Guys,

I am trying to list the values of a dimension in a text box, using concat funtion, I am successfully able to list them out by using the following function but the problem is since my dimension also has 0 or blank values . it lists out 0 values before listing out the actual text values. Can you guys help ? Thanks ,

' &Concat([Field Name1], '

',)

End goal is to have the blank values show up below the text values.

just additional info in case this might help, Field Name 1 which has mostly text values and some blank/0 values , is linked to another Field Name2 that contains numberic values 15,16,17 .

Thanks,

Re: Sorting Data in Text Box

sunny_talwar — Wed, 13 May 2015 15:22:33 GMT

Try this may be:

=Concat([Field Name1], Chr(13), Match(Trim([Field Name1]), '*', ' '))

Re: Sorting Data in Text Box

maxgro — Wed, 13 May 2015 15:30:28 GMT

=Concat(if(len(trim(field))>0,field), '-', -field) & '-' &Concat(if(len(trim(field))=0,field), '-', -field)