topic Dynamic string concatenation & sort in QlikView

Dynamic string concatenation & sort

prasadcm — Thu, 10 Mar 2016 12:28:57 GMT

Hi,

The value in listbox is made of 4 fields as shown above,I need output as shown above
Since 3rd field consists of C & 1st field consists of T....so now 3rd field should come before 1st.

Regards,

Prasad !

Re: Dynamic string concatenation & sort

Chanty4u — Thu, 10 Mar 2016 12:37:12 GMT

jst chk ur sort tab properties

Re: Dynamic string concatenation & sort

rwunderlich — Thu, 10 Mar 2016 16:40:08 GMT

What you are saying is if Field3 is < Field1, concat with F3 first, otherwise F1. So write it that way as an if. I'm using F1 etc to avoid typing out your long field names.

=if(F3 precedes F1

,F3 & F2 & F1 & F4

,F1 & F2 & F3 & F4

)

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: Dynamic string concatenation & sort

prasadcm — Fri, 11 Mar 2016 05:02:11 GMT

Hi rob,

I tried the following

=if(MaxString([Internal Partner company code])< MaxString([Company Code]),

[Internal Partner company code]&'.'&[Internal Partner Company Buline]&'.'&[Company Code]&'.'&[Buisness Line]

,[Company Code]&'.'&[Buisness Line]&'.'&[Internal Partner company code]&'.'&[Internal Partner Company Buline])

I am getting what is needed but u need to select something from listbox.
I want it to be sorted without any selection since I will be using that field in straight table.

Regards,

Prasad

Re: Dynamic string concatenation & sort

prasadcm — Fri, 11 Mar 2016 05:04:25 GMT

Hi,

Dat wont work,i have alrdy tried it.

Regards,

Prasad

Re: Dynamic string concatenation & sort

Digvijay_Singh — Fri, 11 Mar 2016 05:31:59 GMT

Try like this -

=if(only([PartnerCode])< only([CompCode]),

PartnerCode & '.' & BusLine & '.' & CompCode & '.' & PartnerCon,CompCode & '.' & BusLine & '.' & PartnerCode & '.' & PartnerCon)

Re: Dynamic string concatenation & sort

Digvijay_Singh — Fri, 11 Mar 2016 05:35:37 GMT

Use this one -

=Aggr(if(only([PartnerCode])< only([CompCode]),

PartnerCode & '.' & BusLine & '.' & CompCode & '.' & PartnerCon,CompCode & '.' & BusLine & '.' & PartnerCode & '.' & PartnerCon),CompCode,BusLine,CompCode,PartnerCon)

Re: Dynamic string concatenation & sort

PradeepReddy — Fri, 11 Mar 2016 05:48:37 GMT

try to do it in the script instead of chart.

Re: Dynamic string concatenation & sort

sasiparupudi1 — Fri, 11 Mar 2016 07:29:56 GMT

Please post a sample

Re: Dynamic string concatenation & sort

prasadcm — Fri, 11 Mar 2016 10:57:01 GMT

Hi,

This works on selection,but i want it displayed without any selection.

Regards,

Prasad

Re: Dynamic string concatenation & sort

prasadcm — Fri, 11 Mar 2016 11:03:33 GMT

Hi All,

Replace characters with Ascii numbers in a string

I used the code in above link to solve the problem.

Regards,

Prasad