topic Re: Display values which is not selected with multiple Inputs in QlikView

Display values which is not selected with multiple Inputs

Thu, 29 Mar 2012 13:44:50 GMT

Hello Everybody,

I am trying to get / display values which are not selected using multiple inputs (using inputbox).

Eg.

I have a table with product ID, sales and date. The user wants to see total sales of some specific product for particular period. I created the input box to paste multiple Products at a time (usually they select more that 1000). Some products from the inputbox will not be selected as they are not possible to select. So I want to display the products which are not selected in the listbox.

Now I am displaying only the count of selected products using GetPossibleCount(Product_ID)

Any help with this would be appreciated.

Display values which is not selected with multiple Inputs

swuehl — Thu, 29 Mar 2012 14:01:29 GMT

You could try something like this in a text box:

=concat({<Product_ID = e(Product_ID) >} Product_ID,', ')

Re: Display values which is not selected with multiple Inputs

CELAMBARASAN — Thu, 29 Mar 2012 14:02:29 GMT

Hi,

You can Subtract it like

=Count({1} Distinct Product_ID) - GetPossibleCount(Product_ID)

=Count({<Product_ID=E(Product_ID)>} Distinct Product_ID)

Celambarasan