Selection - how to do it? :)

[qlikviewaf]

Hi,

i have those data set as shown below.

I would like to give to the users the possibility to select just with a click the "Cliente" where the "Importo Promessa di Pagamento" has an amount (so is different from null). How i can achieve this?

Thank you!

[krishnacbe]

Hi,

Are you trying to show all the values but ability to select only not null values?

[m_woolf]

Make a listbox for "Importo Promessa di Pagamento"

Right-click the listbox and choose Select All

Or:

Make a button and add an action that does Select in Field and select all.

[vishsaggi]

Is this a table box? If you can use a straight table just add your

dimensions and

expr as

= IF(Sum(Importo Promessa di Pagamento) > 0, Sum(Importo Promessa di Pagamento))

Then supress 0 values in presentation tab.