topic Re: Selection - how to do it? :) in QlikView

Selection - how to do it? :)

qlikviewaf — Wed, 15 Nov 2017 14:04:00 GMT

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!

Re: Selection - how to do it? :)

krishnacbe — Wed, 15 Nov 2017 15:32:01 GMT

Hi,

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

Re: Selection - how to do it? :)

m_woolf — Wed, 15 Nov 2017 16:12:34 GMT

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.

Re: Selection - how to do it? :)

vishsaggi — Wed, 15 Nov 2017 16:36:11 GMT

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.