Discussion Board for collaboration related to QlikView App Development.
I need to get field (INDIC_3) values on textboxes, with the same sorting as the loading sort, using concat and then subfield.
here is what I get:
the green color represent the loading sort wich is correct, and the red color represent what I get with Concat(Distinct INDIC_3)
I tried to read all the threads about the same issue, so I tried using the third parameter of the Concat() with RowNo on the script and on the front end. nothing is working for me
PFA the sample data I'm using for this example
Thank you for your help
Try like below
LOAD INDIC_NIV_0,INDIC_1,INDIC_2,INDIC_3,INDIC_N2,AutoNumber(INDIC_3) as INDIC_3NoFROM[D:\Qlik\Com\test.xlsx](ooxml, embedded labels, table is Feuil1);
Front end: Text box:
=Concat(DISTINCT INDIC_3, ',', INDIC_3No)
View solution in original post
concat function does have sorting option:Concat - script function ‒ QlikView
if you want to do it without changing the script you could do as following:
=concat(distinct INDIC_3,',',match(ord(left(subfield(INDIC_3,' ',3),1))-64,'1','33','5','13'))
@MayilVahanan thank you ! it works