Como criar uma ListBox (Lista Suspensa)

[antoniodneto]

Olá pessoal

A minha base tem diversas colunas ex: FL_CORRENTISTA, COD_SEG, IN_ACORDO, e o conteúdo de cada coluna os seus respectivos valores.

Existe alguma possibilidade de criar uma ListBox, listando FL_CORRENTISTA, COD_SEG e IN_ACORDO, ai de acordo com a opção selecionada um outro filtro listar o conteúdo de cada campo selecionado?

Seria como o Lista Suspensa no Excel.

Obrigado

[Digvijay_Singh]

You can create one island table having all these field names and then create new list box with the expression as -

=$(='['&GetFieldSelections(Dim)&']')

to see the content of selected field in the first list box. Sample attached.

[Digvijay_Singh]

[antoniodneto]

Hi Digvijay,

Sorry I'm using QlikSense, this is a qvw file right? How Can I open it?

[Digvijay_Singh · Accepted solution]

oh ok, here is similar QS version

[antoniodneto]

Is this the magic?

Comment Field Dim1 With "This is a field comment";

Load * inline [

Dim

Dim1

Dim2

Dim3 ];

[Digvijay_Singh]

This is first thing, this is the island table of field names, magic is in the formula used as dimension in 2nd filter pane which converts selected value in first filter to fieldname

[Digvijay_Singh]

Please ignore comment field statement, I just used the sample test data provided by Qlik, using Ctrl 0 0 in script.

[antoniodneto]

Tks a lot Digvijay!! It works perfectly !!!

By the way, Can you help me with another question that I did before?

Tks again!!

[antoniodneto]

Another question!!

Is it possible use the formula into a SUM Expression?

Something like

sum({<CD_EMP = {'33','1505','1508'},variavel={'FAIXA_PC_Entrada'}>}=$(='['&GetFieldSelections(Dim2)&']'))

The SUM will reflect a Field selected in the island table?

Tks!!