Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

QSense
Contributor 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
Contributor II

Re: show more columns in listbox

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
Contributor II

Re: show more columns in listbox

bir_iki.png

I want to see exacty above listbox

Re: show more columns in listbox

See attached qvw.


talk is cheap, supply exceeds demand
QSense
Contributor II

Re: show more columns in listbox

Thanks

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

I can not see values belong to that column

QSense
Contributor II

Re: show more columns in listbox

field.png

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

QSense
Contributor II

Re: show more columns in listbox

field.png

Exactly problem is above

QSense
Contributor II

Re: show more columns in listbox

Hi,

This is my example attached

Community Browser