topic Re: Sorting Issue in QlikView

Sorting Issue

Anonymous — Thu, 04 May 2017 17:29:49 GMT

I have a table ,I need the data list box is will appear in the same sequence at in load script,

Table1:
LOAD * INLINE [
id, data
Data_1, prim
Data_2, second
Data_3
Data_4
Data_5
Data_6
Data_7, business personal
Data_8, business social
Data_9, business third
Data_10, theature
Data_11
Data_12, plan
Data_13
Data_14, path
Data_15, path time
Data_16, path colr
Data_17, ontime
Data_18
Data_19
Data_20, comment
Data_21, ontime sec
Data_22, theee
Data_23
Data_24
Data_27
Data_28
Data_29
Data_30

];

Text box having Concat(DISTINCT data ,'|') expression should concat the field value in the same order as present in load script

Desired Output:-

Data_new

prim
second

business personal
business social
business third
theature
plan
path
path time
path colr
ontime
comment
ontime sec
theee

Re: Sorting Issue

Digvijay_Singh — Thu, 04 May 2017 17:46:45 GMT

Just create one new field using Recno() and use that in concat as third parameter, like this -

Concat(DISTINCT data ,'|',RecNo)

Re: Sorting Issue

Thu, 04 May 2017 17:46:52 GMT

Hi, Shweta

Go into List Box Properties, click on Sort tab then check Load Order as Original. You desired output will be like following.

Re: Sorting Issue

antoniotiman — Thu, 04 May 2017 17:47:25 GMT

Hi,

see Attachment

Regards,

Antonio

Re: Sorting Issue

maxgro — Thu, 04 May 2017 17:49:57 GMT

add a new id2 to the script

LOAD *, rowno() as id2 INLINE [

id, data

Data_1, prim

Data_2, second

and use id2 to sort the concat

=Concat(if(len(trim(data))>0, data), '|', id2)

Re: Sorting Issue

Anil_Babu_Samineni — Thu, 04 May 2017 17:56:18 GMT

Here, you go

=Concat(if(Len(data)>0, data), '|', ID2)

Re: Sorting Issue

Anonymous — Thu, 04 May 2017 18:28:23 GMT

which one is best recno() or rowno

Re: Sorting Issue

Anonymous — Thu, 04 May 2017 18:46:41 GMT

can we implement the same in listbox without checking load order

Re: Sorting Issue

maxgro — Thu, 04 May 2017 19:06:29 GMT

there isn't a best fro your question

RecNo or RowNo?

Re: Sorting Issue

antoniotiman — Thu, 04 May 2017 19:08:12 GMT

See difference

LOAD *,RowNo() as Rowno,RecNo() as Recno INLINE [
id, data
Data_1, prim
Data_2, second
Data_3
Data_4
Data_5
Data_6
Data_7, business personal
Data_8, business social
Data_9, business third
Data_10, theature
Data_11
Data_12, plan
Data_13
Data_14, path
Data_15, path time
Data_16, path colr
Data_17, ontime
Data_18
Data_19
Data_20, comment
Data_21, ontime sec
Data_22, theee
Data_23
Data_24
Data_27
Data_28
Data_29
Data_30
] Where SubField(id,'_',-1) > 15;

Re: Sorting Issue

Anonymous — Thu, 04 May 2017 19:13:43 GMT

thanks

Re: Sorting Issue

Anonymous — Thu, 04 May 2017 19:35:13 GMT

if I want to add all fields in chart dimension but hide those fields which are blank how we can do that

Re: Sorting Issue

Anonymous — Fri, 05 May 2017 04:57:40 GMT

can we customize the sequence that whatever the data entry, it always come in the order of data enriched_1,Enriched_2,Enriched_3