Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone ,
I have columns called one ,two , three.....thrty three
How can I show these columns in list box in order to select one of them and show data linked that column value
My load script is in below,
I want to list 1,2,3,4,...33 in a listbox
LOAD
`EMPLOYEE_NO` as Sicil_No,
BIR as 1,
IKI as 2,
UC as 3,
DORT as 4,
BES as 5,
ALTI as 6,
YEDI as 7,
SEKIZ as 8,
DOKUZ as 9,
`ON` as 10,
ONBIR as 11,
ONIKI as 12,
ONUC as 13,
ONDORT as 14,
ONBES as 15,
ONALTI as 16,
ONYEDI as 17,
ONSEKIZ as 18,
ONDOKUZ as 19,
YIRMI as 20,
YIRMIBIR as 21,
YIRMIIKI as 22,
YIRMIUC as 23,
YIRMIDORT as 24,
YIRMIBES as 25,
YIRMIALTI as 26,
YIRMIYEDI as 27,
YIRMISEKIZ as 28,
YIRMIDOKUZ as 29,
OTUZ as 30,
OTUZBIR as 31,
OTUZIKI as 32,
OTUZUC as 33,
`BIR_2` as [1_2],
`IKI_2` as [2_2],
`UC_2` as [3_2],
`DORT_2` as [4_2],
`BES_2` as [5_2],
`ALTI_2` as [6_2],
`YEDI_2` as [7_2],
`SEKIZ_2` as [8_2],
`DOKUZ_2`as [9_2],
`ON_2` as [10_2],
`ONBIR_2` as [11_2],
`ONIKI_2` as [12_2],
`ONUC_2` as [13_2],
`ONDORT_2` as [14_2],
`ONBES_2` as [15_2],
`ONALTI_2` as [16_2],
`ONYEDİ_2` as [17_2],
`ONSEKIZ_2` as [18_2],
`ONDOKUZ_2` as [19_2],
`YIRMI_2` as [20_2],
`YIRMIBIR_2` as [21_2],
`YIRMIIKI_2` as [22_2],
`YIRMIUC_2` as [23_2],
`YIRMIDORT_2` as [24_2],
`YIRMIBES_2` as [25_2],
`YIRMIALTI_2` as [26_2],
`YIRMIYEDİ_2` as [27_2],
`YIRMISEKIZ_2` as [28_2],
`YIRMIDOKUZ_2` as [29_2],
`OTUZ_2` as [30_2],
`OTUZBIR_2` as [31_2],
`OTUZIKI_2` as [32_2],
`OTUZUC_2` as [33_2],
A1 as A1_2,
A2 as A2_2,
A3 as A3_2,
A4 as A4_2,
B1 as B1_2,
B2 as B2_2,
B3 as B3_2,
C1 as C1_2,
C2 as C2_2,
C3 as C3_2,
C4 as C4_2,
D1 as D1_2,
D2 as D2_2,
D3 as D3_2,
D4 as D4_2,
if(BIR='G',1,0) + if(IKI='G',1,0) + if(UC='G',1,0) + if(DORT='G',1,0) + if(BES='G',1,0)
+if(ALTI='G',1,0) + if(YEDI='G',1,0) + if(SEKIZ='G',1,0) + if(DOKUZ='G',1,0) + if(ON='G',1,0)
+if(ONBIR='G',1,0) + if(ONIKI='G',1,0) + if(ONUC='G',1,0) + if(ONDORT='G',1,0) + if(ONBES='G',1,0)
+if(ONALTI='G',1,0) + if(ONYEDI='G',1,0) + if(ONSEKIZ='G',1,0) + if(ONDOKUZ='G',1,0) + if(YIRMI='G',1,0)
+if(YIRMIBIR='G',1,0) + if(YIRMIIKI='G',1,0) + if(YIRMIUC='G',1,0) + if(YIRMIDORT='G',1,0) + if(YIRMIBES='G',1,0)
+if(YIRMIALTI='G',1,0) + if(YIRMIYEDI='G',1,0) + if(YIRMISEKIZ='G',1,0) + if(YIRMIDOKUZ='G',1,0) + if(OTUZ='G',1,0)
+if(OTUZBIR='G',1,0) + if(OTUZIKI='G',1,0) + if(OTUZUC='G',1,0) as [G Sayısı],
if(BIR='VG',1,0) + if(IKI='VG',1,0) + if(UC='VG',1,0) + if(DORT='VG',1,0) + if(BES='VG',1,0)
+if(ALTI='VG',1,0) + if(YEDI='VG',1,0) + if(SEKIZ='VG',1,0) + if(DOKUZ='VG',1,0) + if(ON='VG',1,0)
+if(ONBIR='VG',1,0) + if(ONIKI='VG',1,0) + if(ONUC='VG',1,0) + if(ONDORT='VG',1,0) + if(ONBES='VG',1,0)
+if(ONALTI='VG',1,0) + if(ONYEDI='VG',1,0) + if(ONSEKIZ='VG',1,0) + if(ONDOKUZ='VG',1,0) + if(YIRMI='VG',1,0)
+if(YIRMIBIR='VG',1,0) + if(YIRMIIKI='VG',1,0) + if(YIRMIUC='VG',1,0) + if(YIRMIDORT='VG',1,0) + if(YIRMIBES='VG',1,0)
+if(YIRMIALTI='VG',1,0) + if(YIRMIYEDI='VG',1,0) + if(YIRMISEKIZ='VG',1,0) + if(YIRMIDOKUZ='VG',1,0) + if(OTUZ='VG',1,0)
+if(OTUZBIR='VG',1,0) + if(OTUZIKI='VG',1,0) + if(OTUZUC='VG',1,0) as [VG Sayısı],
if(BIR='A',1,0) + if(IKI='A',1,0) + if(UC='A',1,0) + if(DORT='A',1,0) + if(BES='A',1,0)
+if(ALTI='A',1,0) + if(YEDI='A',1,0) + if(SEKIZ='A',1,0) + if(DOKUZ='A',1,0) + if(ON='A',1,0)
+if(ONBIR='A',1,0) + if(ONIKI='A',1,0) + if(ONUC='A',1,0) + if(ONDORT='A',1,0) + if(ONBES='A',1,0)
+if(ONALTI='A',1,0) + if(ONYEDI='A',1,0) + if(ONSEKIZ='A',1,0) + if(ONDOKUZ='A',1,0) + if(YIRMI='A',1,0)
+if(YIRMIBIR='A',1,0) + if(YIRMIIKI='A',1,0) + if(YIRMIUC='A',1,0) + if(YIRMIDORT='A',1,0) + if(YIRMIBES='A',1,0)
+if(YIRMIALTI='A',1,0) + if(YIRMIYEDI='A',1,0) + if(YIRMISEKIZ='A',1,0) + if(YIRMIDOKUZ='A',1,0) + if(OTUZ='A',1,0)
+if(OTUZBIR='A',1,0) + if(OTUZIKI='A',1,0) + if(OTUZUC='A',1,0) as [A Sayısı],
if(BIR='U',1,0) + if(IKI='U',1,0) + if(UC='U',1,0) + if(DORT='U',1,0) + if(BES='U',1,0)
+if(ALTI='U',1,0) + if(YEDI='U',1,0) + if(SEKIZ='U',1,0) + if(DOKUZ='U',1,0) + if(ON='U',1,0)
+if(ONBIR='U',1,0) + if(ONIKI='U',1,0) + if(ONUC='U',1,0) + if(ONDORT='U',1,0) + if(ONBES='U',1,0)
+if(ONALTI='U',1,0) + if(ONYEDI='U',1,0) + if(ONSEKIZ='U',1,0) + if(ONDOKUZ='U',1,0) + if(YIRMI='U',1,0)
+if(YIRMIBIR='U',1,0) + if(YIRMIIKI='U',1,0) + if(YIRMIUC='U',1,0) + if(YIRMIDORT='U',1,0) + if(YIRMIBES='U',1,0)
+if(YIRMIALTI='U',1,0) + if(YIRMIYEDI='U',1,0) + if(YIRMISEKIZ='U',1,0) + if(YIRMIDOKUZ='U',1,0) + if(OTUZ='U',1,0)
+if(OTUZBIR='U',1,0) + if(OTUZIKI='U',1,0) + if(OTUZUC='U',1,0) as [U Sayısı],
if(BIR='SI',1,0) + if(IKI='SI',1,0) + if(UC='SI',1,0) + if(DORT='SI',1,0) + if(BES='SI',1,0)
+if(ALTI='SI',1,0) + if(YEDI='SI',1,0) + if(SEKIZ='SI',1,0) + if(DOKUZ='SI',1,0) + if(ON='SI',1,0)
+if(ONBIR='SI',1,0) + if(ONIKI='SI',1,0) + if(ONUC='SI',1,0) + if(ONDORT='SI',1,0) + if(ONBES='SI',1,0)
+if(ONALTI='SI',1,0) + if(ONYEDI='SI',1,0) + if(ONSEKIZ='SI',1,0) + if(ONDOKUZ='SI',1,0) + if(YIRMI='SI',1,0)
+if(YIRMIBIR='SI',1,0) + if(YIRMIIKI='SI',1,0) + if(YIRMIUC='SI',1,0) + if(YIRMIDORT='SI',1,0) + if(YIRMIBES='SI',1,0)
+if(YIRMIALTI='SI',1,0) + if(YIRMIYEDI='SI',1,0) + if(YIRMISEKIZ='SI',1,0) + if(YIRMIDOKUZ='SI',1,0) + if(OTUZ='SI',1,0)
+if(OTUZBIR='SI',1,0) + if(OTUZIKI='SI',1,0) + if(OTUZUC='SI',1,0) as [SI Sayısı],
if(BIR='NA',1,0) + if(IKI='NA',1,0) + if(UC='NA',1,0) + if(DORT='NA',1,0) + if(BES='NA',1,0)
+if(ALTI='NA',1,0) + if(YEDI='NA',1,0) + if(SEKIZ='NA',1,0) + if(DOKUZ='NA',1,0) + if(ON='NA',1,0)
+if(ONBIR='NA',1,0) + if(ONIKI='NA',1,0) + if(ONUC='NA',1,0) + if(ONDORT='NA',1,0) + if(ONBES='NA',1,0)
+if(ONALTI='NA',1,0) + if(ONYEDI='NA',1,0) + if(ONSEKIZ='NA',1,0) + if(ONDOKUZ='NA',1,0) + if(YIRMI='NA',1,0)
+if(YIRMIBIR='NA',1,0) + if(YIRMIIKI='NA',1,0) + if(YIRMIUC='NA',1,0) + if(YIRMIDORT='NA',1,0) + if(YIRMIBES='NA',1,0)
+if(YIRMIALTI='NA',1,0) + if(YIRMIYEDI='NA',1,0) + if(YIRMISEKIZ='NA',1,0) + if(YIRMIDOKUZ='NA',1,0) + if(OTUZ='NA',1,0)
+if(OTUZBIR='NA',1,0) + if(OTUZIKI='NA',1,0) + if(OTUZUC='NA',1,0) as [NA Sayısı],
if(BIR_2='KOS',1,0) + if(IKI_2='KOS',1,0) + if(UC_2='KOS',1,0) + if(DORT_2='KOS',1,0) + if(BES_2='KOS',1,0)
+if(ALTI_2='KOS',1,0) + if(YEDI_2='KOS',1,0) + if(SEKIZ_2='KOS',1,0) + if(DOKUZ_2='KOS',1,0) + if(ON_2='KOS',1,0)
+if(ONBIR_2='KOS',1,0) + if(ONIKI_2='KOS',1,0) + if(ONUC_2='KOS',1,0) + if(ONDORT_2='KOS',1,0) + if(ONBES_2='KOS',1,0)
+if(ONALTI_2='KOS',1,0) + if(ONSEKIZ_2='KOS',1,0) + if(ONDOKUZ_2='KOS',1,0) + if(YIRMI_2='KOS',1,0)
+if(YIRMIBIR_2='KOS',1,0) + if(YIRMIIKI_2='KOS',1,0) + if(YIRMIUC_2='KOS',1,0) + if(YIRMIDORT_2='KOS',1,0) + if(YIRMIBES_2='KOS',1,0)
+if(YIRMIALTI_2='KOS',1,0) + if(YIRMISEKIZ_2='KOS',1,0) + if(YIRMIDOKUZ_2='KOS',1,0) + if(OTUZ_2='KOS',1,0)
+if(OTUZBIR_2='KOS',1,0) + if(OTUZIKI_2='KOS',1,0) + if(OTUZUC_2='KOS',1,0) as [KOS Sayısı],
if(BIR_2='UOA',1,0) + if(IKI_2='UOA',1,0) + if(UC_2='UOA',1,0) + if(DORT_2='UOA',1,0) + if(BES_2='UOA',1,0)
+if(ALTI_2='UOA',1,0) + if(YEDI_2='UOA',1,0) + if(SEKIZ_2='UOA',1,0) + if(DOKUZ_2='UOA',1,0) + if(ON_2='UOA',1,0)
+if(ONBIR_2='UOA',1,0) + if(ONIKI_2='UOA',1,0) + if(ONUC_2='UOA',1,0) + if(ONDORT_2='UOA',1,0) + if(ONBES_2='UOA',1,0)
+if(ONALTI_2='UOA',1,0) + if(ONSEKIZ_2='UOA',1,0) + if(ONDOKUZ_2='UOA',1,0) + if(YIRMI_2='UOA',1,0)
+if(YIRMIBIR_2='UOA',1,0) + if(YIRMIIKI_2='UOA',1,0) + if(YIRMIUC_2='UOA',1,0) + if(YIRMIDORT_2='UOA',1,0) + if(YIRMIBES_2='UOA',1,0)
+if(YIRMIALTI_2='UOA',1,0) + if(YIRMISEKIZ_2='UOA',1,0) + if(YIRMIDOKUZ_2='UOA',1,0) + if(OTUZ_2='UOA',1,0)
+if(OTUZBIR_2='UOA',1,0) + if(OTUZIKI_2='UOA',1,0) + if(OTUZUC_2='UOA',1,0) as [UOA Sayısı],
if(BIR_2='MAC',1,0) + if(IKI_2='MAC',1,0) + if(UC_2='MAC',1,0) + if(DORT_2='MAC',1,0) + if(BES_2='MAC',1,0)
+if(ALTI_2='MAC',1,0) + if(YEDI_2='MAC',1,0) + if(SEKIZ_2='MAC',1,0) + if(DOKUZ_2='MAC',1,0) + if(ON_2='MAC',1,0)
+if(ONBIR_2='MAC',1,0) + if(ONIKI_2='MAC',1,0) + if(ONUC_2='MAC',1,0) + if(ONDORT_2='MAC',1,0) + if(ONBES_2='MAC',1,0)
+if(ONALTI_2='MAC',1,0) + if(ONSEKIZ_2='MAC',1,0) + if(ONDOKUZ_2='MAC',1,0) + if(YIRMI_2='MAC',1,0)
+if(YIRMIBIR_2='MAC',1,0) + if(YIRMIIKI_2='MAC',1,0) + if(YIRMIUC_2='MAC',1,0) + if(YIRMIDORT_2='MAC',1,0) + if(YIRMIBES_2='MAC',1,0)
+if(YIRMIALTI_2='MAC',1,0) + if(YIRMISEKIZ_2='MAC',1,0) + if(YIRMIDOKUZ_2='MAC',1,0) + if(OTUZ_2='MAC',1,0)
+if(OTUZBIR_2='MAC',1,0) + if(OTUZIKI_2='MAC',1,0) + if(OTUZUC_2='MAC',1,0) as [MAC Sayısı],
if(BIR_2='OMA',1,0) + if(IKI_2='OMA',1,0) + if(UC_2='OMA',1,0) + if(DORT_2='OMA',1,0) + if(BES_2='OMA',1,0)
+if(ALTI_2='OMA',1,0) + if(YEDI_2='OMA',1,0) + if(SEKIZ_2='OMA',1,0) + if(DOKUZ_2='OMA',1,0) + if(ON_2='OMA',1,0)
+if(ONBIR_2='OMA',1,0) + if(ONIKI_2='OMA',1,0) + if(ONUC_2='OMA',1,0) + if(ONDORT_2='OMA',1,0) + if(ONBES_2='OMA',1,0)
+if(ONALTI_2='OMA',1,0) + if(ONSEKIZ_2='OMA',1,0) + if(ONDOKUZ_2='OMA',1,0) + if(YIRMI_2='OMA',1,0)
+if(YIRMIBIR_2='OMA',1,0) + if(YIRMIIKI_2='OMA',1,0) + if(YIRMIUC_2='OMA',1,0) + if(YIRMIDORT_2='OMA',1,0) + if(YIRMIBES_2='OMA',1,0)
+if(YIRMIALTI_2='OMA',1,0) + if(YIRMISEKIZ_2='OMA',1,0) + if(YIRMIDOKUZ_2='OMA',1,0) + if(OTUZ_2='OMA',1,0)
+if(OTUZBIR_2='OMA',1,0) + if(OTUZIKI_2='OMA',1,0) + if(OTUZUC_2='OMA',1,0) as [OMA Sayısı],
if(BIR_2='OMB',1,0) + if(IKI_2='OMB',1,0) + if(UC_2='OMB',1,0) + if(DORT_2='OMB',1,0) + if(BES_2='OMB',1,0)
+if(ALTI_2='OMB',1,0) + if(YEDI_2='OMB',1,0) + if(SEKIZ_2='OMB',1,0) + if(DOKUZ_2='OMB',1,0) + if(ON_2='OMB',1,0)
+if(ONBIR_2='OMB',1,0) + if(ONIKI_2='OMB',1,0) + if(ONUC_2='OMB',1,0) + if(ONDORT_2='OMB',1,0) + if(ONBES_2='OMB',1,0)
+if(ONALTI_2='OMB',1,0) + if(ONSEKIZ_2='OMB',1,0) + if(ONDOKUZ_2='OMB',1,0) + if(YIRMI_2='OMB',1,0)
+if(YIRMIBIR_2='OMB',1,0) + if(YIRMIIKI_2='OMB',1,0) + if(YIRMIUC_2='OMB',1,0) + if(YIRMIDORT_2='OMB',1,0) + if(YIRMIBES_2='OMB',1,0)
+if(YIRMIALTI_2='OMB',1,0) + if(YIRMISEKIZ_2='OMB',1,0) + if(YIRMIDOKUZ_2='OMB',1,0) + if(OTUZ_2='OMB',1,0)
+if(OTUZBIR_2='OMB',1,0) + if(OTUZIKI_2='OMB',1,0) + if(OTUZUC_2='OMB',1,0) as [OMB Sayısı]
I want to see exacty above listbox
See attached qvw.
Thanks
but ıhave problen when I selected 1 or 2 or other numbers
I can not see values belong to that column
When I select one of numbers it does not take that field's values
Exactly problem is above
Hi,
This is my example attached