Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
QSense
Creator II
Creator II

show more columns in listbox

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

7 Replies
QSense
Creator II
Creator II
Author

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ı]

QSense
Creator II
Creator II
Author

bir_iki.png

I want to see exacty above listbox

Gysbert_Wassenaar

See attached qvw.


talk is cheap, supply exceeds demand
QSense
Creator II
Creator II
Author

Thanks

but ıhave problen when I selected 1 or 2 or other numbers

I can not see values belong to that column

QSense
Creator II
Creator II
Author

field.png

When I select one of numbers it does not take that field's values

QSense
Creator II
Creator II
Author

field.png

Exactly problem is above

QSense
Creator II
Creator II
Author

Hi,

This is my example attached